AD 91-25-08 R1
Registered aircraft · 657
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:91-25-08-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:91-25-08-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:91-25-08-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:91-25-08-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N83DMCavu Operations LLC · Henderson, NVN8401ACommercial Property Services Group LLC · Wichita, KSN842DYAltimate Transportaton Services LLC · Dallas, TXN8430NFitch John A · Cary, ILN844CKTurpin Time LLC · Helena, MTN850RMDueck Arthur P · Lakewood, OHN853MTK & T Inc · Salt Lake City, UTN859DMDavis Mark E · Pearland, TXN85KSCnet Aviation LLC · Lindale, TXN861HCN861hc LLC · Elk City, OKN866KABad Aire LLC · Aledo, TXN866PMBluview Management LLC · Avon Park, FLN87386Golden Eagle Flyers Inc · Cheyenne, WYN87541Chadbourne Daniel I Jr · Anchorage, AKN87561Forest Aire LLC · Flagstaff, AZN877JBOg Flights LLC · Dover, DEN878DMFly North 421 LLC · Helena, MTN87GKAlpha Zulu Aviation LLC · Spring, TXN87PPAerospace Trust Management LLC Trustee · Wilmington, DEN880JSDodson International Parts Inc · Rantoul, KSN881JPCowboy Aviation LLC · Amarillo, TXN884LPBecton Aviation LLC · Lubbock, TXN88537Gink2 LLC · Elkhorn, NEN88584Dallas Aero & Sales LLC · Poplar, MTN88604Trade Winds Aviation Holdings LLC · Lewes, DEN88606N88606 LLC · Ely, IAN88646Eagle Air LLC · Garden Ridge, TXN888JSElite Aviation Inc · San Jose, CAN88PEFirst Winds LLC · Norfolk, NEN8GALambeth Air LLC · Sitka, AKN8HTServicetec LLC · Kalamazoo, MIN900CBHnl Group LLC · Minnetonka, MNN903JDAirventure LLC · Fort Lauderdale, FLN904BCFox 3 Partners LLC · Virginia Beach, VAN90MKBs LLC · Huntsville, TXN90YAPlane Brilliant LLC · New Port Richey, FLN918BVDietz John W Jr · Westfield, INN922KVKings Oil Tools Inc · Paso Robles, CAN925BKAcom Electronic Measurement Technology Inc · Milpitas, CAN926MTNew London Aviation LLC · Forest, VAN92CVRandall Grier Ministries · Owasso, OKN92DFN92df Slo LLC · Arroyo Grande, CAN936AFVasquez Ahyde E · Brownsville, TXN942SWVascoe Jeffre M · Houston, TXN945BGDavis James H · Corpus Christi, TXN95GMMeinig High Club LLC · Klamath Falls, ORN977BHMotors Inc · Cumming, GAN97DHEmbry Aero Ltd · Greenville, ILN98437Infranco Anthony · Amityville, NYN987MCTwa LLC · Weatherford, OK
Back to AD 91-25-08 R1