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.
N88FXScronce Anthony W · Reno, NVN88GCHuth-Weiss Kathryn W · Prescott, AZN88GEGothreaux William A · Deridder, LAN88GGSchneck Doreen Trustee · Albany, GAN88GKSale Reported · Crestview, FLSale reportedN88GVAllen Timothy J · Petersburgh, NYN88HGBagwell Harold G · Garner, NCN88JCFarooq Tayab · Allen, TXN88JLSummit Concepts Inc · Wilmington, DEN88JVVan Grunsven Gerald B · Hillsboro, ORN88KAStefenelli Aviation N-Tr Inc Trustee · AtterseeN88KCMccarty Lyle H · Eugene, ORN88KMTsukii Toshikazu · Tucson, AZN88LLLarrabee Consulting Group LLC · West Carrollton, OHN88LWRkj Enterprises · Bay City, TXN88MDWaage Matthew L · Elkhart Lake, WIN88MHCaitlyn Aviation LLC · Thousand Oaks, CAN88MRMarkus Stanley L · Oconomowoc, WIN88NGBakke Dale W · Yankton, SDN88NSDaniel Timidaiski · Mukilteo, WAN88PV400 Aviation LLC · Elkhart, INN88PYSegler Max D · Shoreview, MNN88QBAckerman Mendel R · Saint Matthews, SCN88QKLeal Felipe · Missouri City, TXN88QQJprg Aviation Inc · Orlando, FLN88RDLafayette Flying Service LLC · Lafayette, LAN88RFGrant Joseph P · Priest River, IDN88RVMyers Thomas A · Yamhill, ORN88RWRhoads Timothy C · Logan, NMN88RXWilson Ronald L · Lake City, FLN88SSWasson Trevor J · Whitewater, MTN88SWBoline Lonny R · Lincoln, MEN88SYYamashita Bruce · Honolulu, HIN88TFHarts Joel D · Coffeyville, KSN88THEaa Aviation Foundation Inc · Oshkosh, WIN88TURv There Yet ? LLC · Lewes, DEN88UMSchefer Charles W L · Warrenton, VAN88VJWilson Kenny · Idaho Falls, IDN88VLMccullough Peter M · Evansville, INN88WCClobes Warren J · Evansville, WIN88WEWolfenden Enterprises Inc · Vero Beach, FLN88WHThomas Robert R · Rochester, MNN88WSChamberlain Donald R · Simsbury, CTN88WWQwest Aviation LLC · Edwardsburg, MIN88YCJorgensen Stephen A · Dallas, TXN88YSOak Trees LLC · Wilmington, DEN88YWCharlston Michael M · Haleiwa, HIN88YZHultzapple Ted D · Farmington, NYN88ZHLearn 2 Fly LLC · Cantonment, FLN89005Singh Fiyaad · Ocoee, FL
Back to AD 90-04-06 R1