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.
N79DAPahlisch Homes Inc · Bend, ORN79DMKsg Capital LLC · Casper, WYN79TEPollard Aircrfaft Sales Inc · Fort Worth, TXN7ABBce Jets LLC · Cuero, TXN7HJHessjet LLC · Mc Donald, TNN7WFFang Aviation LLC · Wichita Falls, TXN7YAVander Dussen Robert · Clovis, NMN7ZGHhwr Whitetail Ranch LLC · Waco, TXN80Federal Aviation Administration · Oklahoma City, OKN800AWUS Department Of State · Melbourne, FLN800GMCadre Aviation Services LLC · San Antonio, TXN800MTTarp-It Air LLC · Ellensburg, WAN800WTBode Aviation Inc · Albuquerque, NMN801CBBaugh Aviation Services LLC · Orem, UTN802CAThree Thirty Three LLC · Collierville, TNN802QTuskegee Leasing LLC · Sioux Falls, SDN803SCStrom Law Firm LLC · Columbia, SCN804Abc Aviation LLC · Gonzales, LAN804CVPlastic Ingenuity Inc · Cross Plains, WIN804MRUS Department Of Homeland Security · Washington, DCN804RDLonestar Aviation LLC · Kalispell, MTN805LCW Brown Enterprises Inc · Durant, OKN806SQBeco Aviation LLC · Nevada, TXN807BWTejama LLC · Amarillo, TXN807EXFrontera Flight Holdings Inc · Dover, DEN807JCGwu LLC · Saint James, MON807MBJ&P Aviation LLC · Jasper, ALN807MRUS Department Of Homeland Security · Washington, DCN808ACInterwings Aircharter Corp · Lewes, DEN808CEOpen Air LLC · Glendale, AZN808MRUS Department Of Homeland Security · Washington, DCN809PSP & P Air LLC · Wilmington, DEN80AB80ab Group LLC · Wichita Falls, TXN80BZMiddle Tennessee State University · Murfreesboro, TNN80CPBf Air LLC · Panama City, FLN80FMTrns Solutions LLC · Lewes, DEN80JHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN80PTCb80pt LLC · Stuart, FLN80WMAt Aero LLC · Wilmington, DEN81Federal Aviation Administration · Oklahoma City, OKN8100LDynamic Avlease Inc · Bridgewater, VAN8100VDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeN810BEChrysler Aviation Inc · Van Nuys, CAN810MRUS Department Of Homeland Security · Washington, DCN810TCSanborn Map Co Inc · Colorado Springs, CON811JANature Coast Aviation LLC · Homosassa, FLN811SH1212012 LLC · Omaha, NEN811VGTwo Oceans 555 LLC · Fort Myers, FLN811WEWarmont Company · Midland, TXN812HACentral Virginia Aviation Inc · North Dinwiddie, VA
Back to AD 90-06-13