AD 90-04-06 R1
Registered aircraft · 68,367
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.
N11CKEagle Aeroworks LLC · Chesterfield, MON11CLCrowder Zura R · Marion, MTN11CUPockrus Pat B · Mineral Wells, TXN11CWJabez Aviation LLC · Petaluma, CAN11CYOdonnell Justin M · Amelia, OHN11DC11dc LLC · Broomfield, CON11DKDunlop D Bruce · Lopez Island, WAN11DMSuburban Aircraft Leasing And Sales LLC · Sylvania, OHN11DUMcginnis Terry S · Surprise, AZN11ETGeygan Thomas J · Cincinnati, OHN11EWFrank Jerry W · Vonore, TNN11FLBell Christopher K · Ashley, OHN11FULow Country Soaring Association · Ridgeland, SCN11GERusso James F · Liberty, SCN11GFCompton Robert · Groveland, CAN11GKBaden Michael · Waxhaw, NCN11GNHaley James M Trustee · Edmond, OKN11HAVintage Aero Inc · Brandon, FLN11HCConway Philip J · Chatfield, MNN11JCWahlin Donald D · Stoughton, WIN11JGMorrison Robert H · Fort Denaud, FLN11JKHowen Timothy Ray · Niagara, WIN11JPRiner Mark G · Bartlesville, OKN11JUPottorff Gregory K · Wayne City, ILN11JVHoltz Jeff · Liberty Lake, WAN11JWWhite Blaine S · Castlewood, VAN11KAlbers Edward C · Burlington Flats, NYN11KACloudbase Inc · Seattle, WAN11KCCunningham Kevin M · Alexandria, MNN11KYKlad-Air LLC · Catlett, VAN11KZHigh Tale LLC · Saint Anthony, IDN11LTG T Flying Club LLC · Bellaire, TXN11MBYoungstown Warren Development Partners · Youngstown, OHN11MCSchwenk Alan G · Tolono, ILN11MFCroom Aviation LLC · Port Saint Joe, FLN11MHSellmeyer Scott M · Wichita, KSN11NInternational Air Services Inc Trustee · Carson City, NVN11NLGould Leland E · Kirkland, WAN11NNLamm Russell N · Wernersville, PAN11NTSabb Anthony · Wetumpka, ALN11PAFelpel Craig D · Palmer, AKN11PJSwift Ralph Jr S · Lebanon, TNN11PKKirik Paul J · Moline, ILN11PWHaszard John R · Ophelia, VAN11PXMuehlberg Stephen E · Newcastle, OKN11PYCuller John T · Arvada, CON11QTAv8rs LLC · Sugar Valley, GAN11RGTurner William R · Dexter, MON11RSRinker Kraig · Winlock, WAN11RWSimonye Curtis F · Holmes Beach, FL
Back to AD 90-04-06 R1