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.
N53603Wings Over Texas Holdings LLC · Denton, TXN5360HEastern Stearman Inc Trustee · Leesburg, VAN5360JFly Montana LLC · Miles City, MTN5360LKitzmiller Peter Charles · Seattle, WAN5360WShaffer Thomas D · Round Rock, TXN53611Aero Mobil Inc · Wilmington, DEN5361HNall Melvin J · Luthersville, GAN5361KLong Island Soaring Association · Shirley, NYN5361NKdb LLC · Underwood, IAN5361WRoberts Misty L · Fountain Hills, AZN53622Mc Air LLC · Miami Beach, FLN5362HMccue Tedd R · Eveleth, MNN5362LTiedemann Douglas A · Skaneateles, NYN5362UHebert Loree W Jr · Saint Francisville, LAN5362XSky West Aviation Inc Trustee · Albuquerque, NMN53630Arlington Flight Services Inc · Arlington, WAN53632Siple Aviation LLC · Kalispell, MTN5363HBauer Dereck R · Springfield, ORN5363JPulliam Joe Clinton Jr Trustee · Pilot Point, TXN5363KMission Aviation Training Academy · Arlington, WAN5363LTeehee Max L · Searcy, ARN5363SOwens Scotty · Crofton, KYN5364KAir S&T LLC · San Juan Capo, CAFirst renewal noticeN5364POwens Flight Training LLC · Lafayette, LAN5364WCowell Clayton R · Garvin, OKN5364ZHughes Tony W · Irmo, SCN53651Christiansen Aviation LLC · Wilmington, DEN5365HVyfvinkel Frederick J · New Smyrna Beach, FLN5365QWelborn Mark · Boonville, NCN5365SGamm Stephene Wade · Warrenton, VAN5365WPugh Harrison B · Tallahassee, FLN53663Iron Shield Aviation LLC · Fort Pierce, FLN5366FGoodrich James · Jacksonville, MON5366HShannon Harry D · Bartow, FLN5366JSlipstream Aviation LLC · Calera, ALN5366KAmerican Patrols Inc · Midland, TXN5366LDurnal William H · Washington, NCN5366MHillsboro Aero Academy LLC · Hillsboro, ORN5366WM & S Aviation LLC · Lebanon, MON5367FBlackburn Kenneth P Trustee · Dubuque, IAN5367HWingsleasing LLC · Wichita, KSN5367LMiller Grady F · Kingsland, TXN5367PBerg Robert M · Culver, ORN5367ZAdvance Aviation Inc · Dover, DENon-citizen corporation, flight hours not reportedN5368HPacific Flight Aviation LLC · Costa Mesa, CAN5368JJones Anesthesia LLC · Arcadia, INN5368MPacific Union College · Angwin, CAN5368TAviation Here LLC · Lino Lakes, MNN5368WFuller Jonathan T · San Antonio, TXFirst renewal noticeN5368ZTevik Michael A · Provo, UT
Back to AD 90-04-06 R1