AD 90-06-13
Registered aircraft · 1,827
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:90-06-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-13')
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:90-06-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-13') 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.
N703MDavis Aviation Inc DBA · Brandon, MSN704DAJamair LLC · Lynchburg, VAN705SPSealandsky LLC · Santa Fe, NMN706AFJet Air Inc · Iowa City, IAN706XTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN7070AGlobal Aircraft Trust Inc Trustee · Cheyenne, WYN707LMFlying Ace 75 LLC · Wilmington, DEN707PFEagle Creek Aviation Inc · Longview, TXN707WWgi Leasing Inc · Vancouver, WAN70ECKb Air LLC · Mason, OHN70FS2141 Corp · Wilmington, DEN70KBCheckerboard Aviation LLC · Bluffton, SCN71Federal Aviation Administration · Oklahoma City, OKN710MLBpt Aviation LLC · Butler, PAFirst renewal noticeN710NCNorth Country Aviation Inc · Gaylord, MIN710VPTx N710vp LLC · Austin, TXN711CCCtwa Investments Inc · Springfield, MON711GFIpo II LLC · Wheeling, ILN711KTBbjs Investments LLC · Waukesha, WIN711LTBlue Skies Aviation Of Daytona Inc · Ormond Beach, FLN711UST J Mccarthy Management LLC · Dallas, TXN711XSSteiner Gp LLC · Weatherford, TXN712BDBravo Delta Holdings LLC · Austin, TXN713WLOx Aviation LLC · Lewes, DEN715RDHalls Aviation LLC · Charleston, SCN716APButler Aviation Inc · Houma, LAN716BRTiburon Aviation II LLC · Dallas, TXN716DDS2 Air LLC · Las Vegas, NVN716SNsa II LLC · Frankfort, NYN717CBPhysicians Air Transport LLC · Hot Springs, ARN717CHAviation Trading Partners LLC · Shawnee, KSN717DBlountville Aviation LLC · Blountville, TNN717TRTrue Airspeed LLC · Pace, FLFirst renewal noticeN717VLRebus III LLC · Owasso, OKN719BHWilliams Farms LLC · Panhandle, TXN719RM3v LLC · Yalesville, CTN719WRBroadband Of Indiana LLC · Owensboro, KYN71KGFarwell Flash Aviation LLC · Farwell, TXFirst renewal noticeN71PPRoberts Motor Company LLC · Amarillo, TXN71VTWestern Wings Corp · Roseburg, ORN71WHGemini 9 LLC · Austin, TXN72Federal Aviation Administration · Oklahoma City, OKN7202YBoeing Co · Berkeley, MON721BCJh Aircraft Services LLC · Dover, DEN721EAAcellerated Interventional Orthopedics Pllc · Lawton, OKN721NBOneonta Trading Corp · Wenatchee, WAN721RDKing Edward Inc · Cullman, ALN721TFfm LLC · El Paso, TXN722CVMile High 5280 LLC · Goldsboro, NCN723TABank Of Utah Trustee · Salt Lake City, UT
Back to AD 90-06-13