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.
N9210MHahn David · Port Lavaca, TXN9210SBazemore Dennis A · Ingleside, TXN9210VHarrison Joe · Atlanta, TXN92115Stanger Joseph E · Willow, AKN9211CClark Michael J · Grapevine, TXN9211JBrown Herbert R · Halls, TNN9211MSowers James Dalton · Park City, KYN9211VMorrissey Thomas A · Peachtree City, GAN9211ZSchacht Michael A · Torrance, CAN9212JJones Greg E · Thomasville, GAN9212LSmith Randall G · Salem, ORN9212VKocher Edward A · Longview, TXN92131Cavu Flyers Of Long Island Inc · Ronkonkoma, NYN9213JRegistered aircraftN9213KCarver Clarence K · Lutz, FLN9213YCarty Eric · Anchorage, AKN92140Poplar Grove Airmotive Inc · Poplar Grove, ILN92141High Flight Academy LLC · Allison Park, PAN9214ATerhune Larry W · Saginaw, TXN9214JSale Reported · Hurdsfield, NDSale reported, pending cancellationN9214SC&L Aviation LLC · New London, WIN9214VGostomski Michael J · Yacolt, WAN92159Buster Aviation LLC · Harveys Lake, PAN9215JGrizzard Shawn C · Hayden, IDN9215LDipietro Ian · Westfield, MAN9215SGarner James L DBA · Pelham, ALN9215VGonzalez Cruz · North Las Vegas, NVN92161Skywarrior Flight Training Inc · Pensacola, FLN92169Welch William Ben · Danville, ILN9216DBlackbird Aviation LLC · Bedford, PAN9216HBurgess Alan P · Corona, CAN9216JSantana Alexandre C · Long Beach, CAN9216LLawrence Guy A · Bakersfield, CAN9216MLewellen Richard H · Mount Vernon, WAN9216NSligh Mark G · Cantil, CAN9216TLudwigson Joel · Inver Grove Hts, MNN9217DBischoff Danielle I · Palmer, AKN9217JWaicekauskas Joe · Raymondville, MON9217KR & R Air Inc · Wilmington, DEN9217MMullenbach Arnold D · Tucson, AZN9217TRegistered aircraftN9217XSkyborne Airline Academy Inc · Vero Beach, FLNon-citizen corporation, flight hours not reportedN9218DMaestas Jonathan M · Wright City, MON9218RFishe Flying Corp · Vero Beach, FLN9218SSurette Phillip · Vail, CON9218VTerrell Aviation Inc · Terrell, TXN92194Ace Aeromotive Inc · Miami, FLN9219HKful Flyers Foundation Inc · Fullerton, CAN9219KJones Robert M · Brooksville, FLN9219LHart Gene E · Ridgecrest, CA
Back to AD 90-04-06 R1