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.
N54990Hoffman Maurice M · Bowdle, SDN5499PLabelle Consulting Group Inc · OntarioN5499QCronce Charles Scott · Pacifica, CAN5499WVerchick Peter A · Jacksonville, FLN549ACWhitaker James C · Washington, NCN549BKBarenfeld Marc F · Angels Camp, CAN549DMCallaghan Jerry R · El Paso, TXN549JTPas Aviation Inc · Modesto, CAN549MAHinkle Airspray Inc · Cavalier, NDN549RVDelzell David Wayne · Heath, TXN549SSullivan Walter E Jr · Speirit Lake, IDN549SCSpartan Education LLC · Tulsa, OKN549ZWMartin Riley J · Talkeetna, AKN54AHD&L Leasing Montana LLC · Kalispell, MTN54BCloud Nine Ventures LLC · Riverview, FLN54BAEmerald City Aircraft Leasing Inc · Port Orchard, WAN54BJJohns William L · Paola, KSN54BWWalker D B · Rougemont, NCN54CSO'Shea James · West Grove, PAN54DLMorris Samuel A · Prineville, ORN54ELCascade Air LLC · Trout Run, PAN54FDDefibaugh Fred M · Chino Valley, AZN54GMCiommo William J · Spring Hill, FLN54HMSky West Aviation Inc Trustee · Albuquerque, NMN54HSHenderson State University · Arkadelphia, ARN54HYEngler Eric M DBA · Cass City, MIN54JASan Carlos Flight Center Inc · San Carlos, CAN54JMAviation Institute Of Maintenance · Virginia Beach, VAN54JTEhlers Louis H · Sedgwick, KSN54KHHertenstein Kevin Wayne · Lutz, FLN54KKTemple Donald G · Amarillo, TXN54LHolzsweig Leon Gerald · Dallas, TXN54LFTopliff John · Goodland, KSN54LHThrew Timothy G · Yates City, ILN54LJPoulton Douglas E · Castro Valley, CAN54LPPerry Jeffrey Kevin · Cumming, GAN54MDDe Marino Michael E · Marietta, GAN54MFFaulkner Max R · Bourbon, INN54MKKuhn Morris L · Dallas, TXN54MTMay Rose Ellen · Hampshire, ILN54PPHancock Andrew M · Kettle Falls, WAN54PRReimer Lynn C · Sioux Falls, SDN54RLTrimble Steven L · Tallahassee, FLN54RRValentin Jose E · Murrieta, CAN54RSIreland Brian T · Springville, UTN54RVEbrahimi Mazda · Gerradstown, WVN54SGBiondo Nicholas P · Norfolk, VAN54TLArmstron Kevin L · Corvallis, ORN54TXBail Air LLC · Port Saint Lucie, FLN54VBas Part Sales LLC · Greeley, CO
Back to AD 90-04-06 R1