AD 90-04-06 R1
Registered aircraft · 68,377
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-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.
N4793JSheco Inc · Aloha, ORN4793LWhitley Carol E · Kingwood, TXN47941Engineering Forensics Inc · Glen Burnie, MDN47943Louiewex Corp · Dover, DEN47945Countee Roger Brendan · Los Angeles, CAN4794LFerraro Henrik L · Grand Island, NYN47953Mountain Aviation Associates LLC · Midland, TXN47954Jennings James A · Fredericktown, OHN47955Southeastern Minnesota Flying Club Inc · Rochester, MNN4795LN383j LLC · Henderson, NVN4795MMountain Air Inc · Quincy, CAFirst renewal noticeN4795TCammack Van R Jr · Willow Park, TXN47965Reid Brian M · Boise, IDN47968Grimes Mike · Yukon, OKN47969Thomason Eric A · Georgetown, TXN4796AThompson Muriel K · Eagle Pass, TXN4796VPittman Robert · Ocala, FLN47971Five X Five Flight Inc · The Woodlands, TXN47981Sabetha Flyers Inc · Sabetha, KSN4798EClark Robert · Junction City, KSN4798LThompson Michael · Stacy, MNN4798RTriple F Flying Inc · Benton, PAN4798THrv Holdings LLC · Camp Hill, PAN4798ZAnderson David J · Fridley, MNN47995Raab David A · York, PAN4799ANew England Aircraft Detailing LLC · Webster, MAN4799TSale Reported · Omaha, NESale reportedN4799ZRegistration Pending · Carefree, AZRegistration pendingN479ACVick Vernon A · Dublin, OHN479BKTensas Taildraggers LLC · Saint Joseph, LAN479CNFlight World Inc · San Juan, PRN479FLImmell John A · Chillicothe, OHN479JAYale Companies LLC DBA · Indianapolis, INN479NTFlight World Inc · San Juan, PRN47AFL & J Aviation Inc · Atwater, CAN47ASM D Ham LLC · Conover, NCFirst renewal noticeN47ATPutman William C · Bigfork, MTN47BBRogers Joseph O III · Fernandina Beach, FLN47BJMisunas Mark · Daytona Beach, FLN47BLLade Burton G · Bemidji, MNN47BNCavorite Aviation LLC · Lehi, UTN47CDickey Tod V · Phoenix, AZN47CBBias Alexandru S · Soldotna, AKN47CSTropicalproperties LLC · Lewes, DEN47CTSweetwater Flyers LLC · Emporia, KSN47CWPetersen Alfred Charles · Buffalo Grove, ILN47DCL&D Joint Sealing LLC · Fairbury, NEN47DERichards Ronald W · Grant City, MON47DHBeard Donald Ray · Bulverde, TXN47DLFairley Michael L · Shawnee, KS
Back to AD 90-04-06 R1