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.
N7739GFlyguys 172 LLC · Liberty, NCN7739NSenia John A · Berlin, CTN773ACDuke Anthony Jr · Alvin, TXN773AGSky West Aviation Inc Trustee · Albuquerque, NMN773AKKlausler Andrew T · New Market, MNN773BAMustang Sally Aviation LLC · Camden, SCN773GCareer Pilot Training LLC · Wilmington, DEN773NDUniversity Of North Dakota · Grand Forks, NDN773RFLoper Scotty L · Midlothian, TXN773RVPearson Mark · Goodyear, AZN773SPFox Flying Club Inc · Wheaton, ILN773WGower Scott B · Shelbyville, KYN7740HDrum Danny R · Anchorage, AKN7740MMason Graham E · Olympia, WAN7740NLenderman Steven E · Sharpsburg, GAN7740UPiper Aircraft Inc · Vero Beach, FLN7740WReiger Roger L · Lafayette, INN7741DJacko Josh E · Anchorage, AKN7741GCaviness Dewayne · Chico, CAN7741NBrindle Richard L · Pleasant Hall, PAN7742DSims Robert E · Richardson, TXN7742KHanson Rustin W · Spokane, WAN7742MGribble Ted · Paris, TXN7742NDistler Robert · Northborough, MAN7742WDupont Micheal Rene · East Taunton, MAN7743DHann James M · Ballwin, MON7743HDavis Lawrence J · Wasilla, AKN7743MPatry Aeronautical Institute · Kalispell, MTN7743NRegistered aircraftN7743WAtigun Aviation LLC · Sheridan, WYN7743YSchroeder David C · Norfolk, NEN7744HCreglow Jacob A · Anchorage, AKN7744KOhlau Mark A · Wellington, NVN7744MMike Clark Trucking Inc · Colton, CAN7744SVista Air Inc · Pacoima, CAN7744TDickert Investments Holdings LLC · Cave Creek, AZN7744WShotwell Michael · Dallas, GAN7744YCossette Aircraft LLC · Laporte, MNN7745DSale Reported · Joseph, ORSale reportedN7745GSuperhawk N7745g Owners' Group LLC · Bend, ORN7745KDe Vecchi Guiancarlo Sergio · Montague, NJN7745MGsh Of Alabama LLC · Huntsville, ALN7745NAppealing Adventures Inc · Canadensis, PAN7745WSchaff Investments LLC · Stone Mountain, GAN7746BMartin Gavin R · Los Angeles, CAN7746DDobson Garland J · Willow, AKN7746FWilliams Dwight J · Wichita, KSN7746KBuergel Sandra J · East Aurora, NYN7746YSnow Robert I · New Caney, TXN7747GKelley Aircraft LLC · Weyers Cave, VA
Back to AD 90-04-06 R1