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.
N75382FAA Flying Club Inc · Springfield, VAN75383Beaman Brice S · Alger, OHN75384Primost Brian C · North Brunswick, NJN75386Three Piloteers LLC · Bloomington, INN7538DOeser Laura Ann · La Grange, TXN7538FSwensen Nathan E · Winnemucca, NVN7538VLee Walker S · Searcy, ARN7538YEdwards John G · Stoneville, NCN75392G B Aviation Inc · Fort Lauerdale, FLNon-citizen corporation, flight hours not reportedN7539DEaa Chapter 99 Inc · Vero Beach, FLN7539FHerkstroeter Caleb · Fairbanks, AKN7539RShanahan Michael P · Cottage Grove, ORN7539WMccormick Michael J · Pocatello, IDN7539YChristianini Cassio Pereira · Plantation, FLN753ATSapient Air LLC · Hood River, ORN753GWAtp Aircraft 4 LLC · Wilmington, DEN753JBCraig Connor J · Mesa, AZN753KSCoastal Alabama Aviators LLC · Daphne, ALN753NDUnd Aerospace Foundation · Grand Forks, NDN753RJMeyer Christopher R · Colchester, CTN753TBig Bend Soaring Inc · Port Orange, FLN7540DVanhouten Eric · Tunkhannock, PAN7540FMeierotto Noah J · Two Rivers, AKN7540GKelley Aircraft LLC · Weyers Cave, VAN75417Mutzenroth LLC · Stanwood, WAN7541RHoover Michael H · Baxter, TNN7541WPiaquadio Dennis J · Newburgh, NYN7542GNelson Frank H · Tuscaloosa, ALN7542RCarr Scott A · Allen, NEN7542VCoastal Cosmetic And Implant Denistry LLC · Miramar Beach, FLN7542WRegistration Pending · Rush City, MNRegistration pendingN7542YLyle Eugene W · Honesdale, PAN7543DBerg Butch A · Duluth, MNN7543GTrue Course LLC · West Monroe, NYN7543WHobbs Michael S · Midland, TXN75441Bohl Howard M Jr · Long Beach, CAN7544FGrundy James W · West Greenwich, RIN7544JHewitt Robert J · Ringwood, NJN7544RReyes Aviation Inc · Middletown, DEN7544UDoherty David W · O Fallon, MON7544VGavazzo Victor Grille · Saint Peters, MON7544WSchrag Douglas R · Pretty Prairie, KSN7545JP D Q Space Arrow Inc · Atlanta, GAN7545KSnead Doug · Derby, KSN7545RWoodworth Rachel L · Louisville, KYN7545W7545w LLC · Liberty, SCN7546FPutman James G · Guntersville, ALN7546YBrilliant Holdings LLC · Winfield, MON7547DHawkins Laurie M · Birch Run, MIN7547GMutter William D · Chelan, WA
Back to AD 90-04-06 R1