AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.
N6005JTextron Aviation Inc · Wichita, KSN6005SCompass Rose Aviation LLC · Derby, KSN60062Textron Aviation Inc · Wichita, KSN60065Brewer Michael M · Naperville, ILN60067Kinsella Joseph R · Jackson, WYN60069Moody Gary M · Osage, IAN6006BRockfield Investments LLC · Hurricane, UTN6006NFraser Shane · San Marcos, TXN6006RPpb Aviation Management Inc · Wading River, NYN6006XTextron Aviation Inc · Wichita, KSN60072Torres Guillen Jesus F · Gridley, CAN60074Barba John C · Missoula, MTN60075Zaier Alan S · Saint Paul, MNN6007ATextron Aviation Inc · Wichita, KSN6007BSkydive Deland Inc · Deland, FLN6007JAldrich Richard G · La Habor, CAN6007RMaster Jacob M · Waddy, KYN60082Trinity Trust LLC · Fort Smith, ARN60087Butcher David W · Radford, VAN6008ABreton Paula Jean · Carrollton, GAN6008BKarella Howard · Fairbanks, AKN6008GBernadt Aviation Inc · Steinauer, NEN6008TYoungman Lawrence J · Penn Yan, NYN6009MKd 172 Ventures I LLC · Bellevue, WAN6009POh Air LLC · Mentor, OHN6009RCape Aerial Tours DBA · Chatham, MAN6009TGies Paul E · Wauwatosa, WIN6009VMaui Aviators LLC · Pukalani, HIFirst renewal noticeN600BFarley Bobby Joe · Lawton, OKN600CGAnderson Cody J · Orono, MEN600EERieman Sylvia · Newbury Park, CAN600HBCoastal Aerops LLC · Montrose, ALN600HFSky Fox Aviation LLC · Eureka, CAN600JFAerial Scouting Solutions LLC · Sioux Center, IAN600NUN600nu LLC · New Meadows, IDN600PKGetzel Air LLC · Conover, WIN600RLElk Properties LLC · Monroe, LAN600SUFlying Aggies · Stillwater, OKN600VVMindy Limited LLC · Muscatine, IAN600XPPintail Aero LLC · Shreveport, LAN601Mont Belvieu Materials Inc · Mont Belvieu, TXN60100Malaspina Anthony J · Caldwell, IDN60108Weakley Bobbi J · Chapmansboro, TNN6010AHolley William E · Kilgore, TXN6010BSwanson Paul W · Turlock, CAN6010FGlodowski Brian D · Bergland, MIN60115Leineke Brittan Dene · Orangevale, CAN60116Winglers Aviation LLC · San Ramon, CAN60119Hugo Emman P A · Livingston, TXN6011AAero Valkaria LLC · Palm Bay, FL
Back to AD 79-10-14 R1