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.
N556PAAviator Corp · Wilmington, DEN556PCChristiansen Aviation LLC · Wilmington, DEN556PSPotter Mark W · Portland, ORN556RAReece Construction Co Inc · Colt, ARN556RJHastings Rick Joe · San Antonio, TXN556RMMorrison Robert J · Rock Hill, SCN556RVKetter Ralph J · La Luz, NMN556SCSpartan Education LLC · Tulsa, OKN556SHNovember Alpha LLC · Dover, DEN556SPTexas State Technical College · Waco, TXN556WHRobert L Stephens · Argyle, TXN55700Curry Edwin A · Pearland, TXN55701Level Up Aviation LLC · Newton, ALN55702Seay Horace M · Desoto, TXN55706Camp Justin P · Edwall, WAN5570FCherokee Adventure Corp · Wilmington, DEN5570MFlythebat.Com LLC · Chicago, ILN5570URegistration Pending · Mesa, AZRegistration pendingN5570ZShippers Lee D · Wolcott, NYN55711To Ivan K · Auburndale, FLN55715Ricker Alexander · Spur, TXN55716Norby Aviation LLC · Hopkinton, MAN55719Coffey County Airport · Burlington, KSN5571MEdwards Larry N · Saint Joseph, MON5571QBerry Charles P · Monroe, NCN5571VColeman Douglas E · Tallahassee, FLN5571ZGlass John · San Luis Obispo, CAN55722Cactus Aero LLC · Haslet, TXN55724Parker David G · Bristol, TNN55726Diedeman Thomas A · Lake City, FLN5572UPoor Farmer Aviation LLC · Saint Marys, OHN5572VWood Charles S · Fox Island, WAN5572ZGilmer Rickey W · Cropwell, ALN55730K&D Ip LLC · Chicago, ILN55731Leary Dennis E · Chesapeake Beach, MDN55736Fox Ralph W II · Wilmington, NCN55738Wenner William E · Kechi, KSN55739Kepfer Robert · Felton, DEN5573QAthens Neurology Professional Association · Athens, TXN5573WHokanson Elijah R · Ashby, MNN5573ZHerrick David · Mont Vernon, NHN55742Doyal William T · Visalia, CAN55743B&R Aircraft LLC · Wadsworth, OHN55744Williams Mike · Hartsville, INN55746Mccoy Michael E · Sanford, NCN5574HAjmi Amal R · Fairbanks, AKN5574MSimpson David B · Oakhurst, CAN5574PPluck Mervyn M · Glendora, CAN5574QDonovan Timothy P · Wichita Falls, TXN5574UCooper Nicholas A · Plano, TX
Back to AD 90-04-06 R1