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.
N94211Jskp Enterprises LLC · Dover, DEN94219Feenstra Patrick · Scottsdale, AZN9421AWillie Brett A · Decorah, IAN9421DJeff Air Pilot Services LLC · Shelbyville, INN9421EStroemsvik Kristian · Strasburg, VAN9421ZL&W Leasing LLC · Smyrna, TNN94227Dodson International Parts Inc · Rantoul, KSN9422BFallbrook Air Service · Fallbrook, CAN9422HFort Smith Flying Club Inc · Fort Smith, ARN9422KFaulkner Harry E Jr · Bethel, AKN9422TGraves Frank C · Nocona, TXN9422UHortman Ryan Davis · Summerville, SCN9422XLittle Bird Airways LLC · Hamburg, NYN94237Brett Ryan J · Wasilla, AKN9423ADyer Shane E · White Hills, AZN9423BDrean Alelandre C · Ajo, AZN9423MPaquette Ralph H Jr · Apalachin, NYN94244Bryant Kenneth D · Black Diamond, WAN9424EAero Equities LLC · Ventura, CAN9424FOwens Mark T · Zionsville, INN9424TGill Melvin L Jr · Nashville, TNN9425AZimmerman Scott Andrew · Palmdale, CAN9425BGloeckler Alex · Pearl City, ILN9425CInternational Air Services Inc Trustee · Carson City, NVN9425HWingsleasing LLC · Wichita, KSN9425TBlue Skies Flying Services LLC · Blandon, PAN9425XOatney Jared C · South Hutchinson, KSN94260Sutton Aircraft Salvage LLC · Palmer, AKN94263Hitch Aviation Inc · Malta, MTN94266Braun Kristy J · Fairbanks, AKN94267Hop Props LLC · Houston, TXN9426CBenson Fred B · Cle Elum, WAN9426EDarcy Aviation LLC · Danbury, CTN9426KO Max Aviation · Willowbrook, ILN9426XBradley Brunhilde K Trustee · Litchfield Park, AZN9427MWillthedrill LLC · Las Vegas, NVN94285Great Lakes Enterprises · Heron, MTN9428AHoyt Richard A · Webster Groves, MON9428CJones Kathleen W · Springfield, ORN9428GSecond Wind Aviation Corp · Friday Harbor, WAN9429ARegistration Pending · Chicago, ILRegistration pendingN9429CLanham Rex E Jr · Boise, IDN9429UTangleport LLC · Amarillo, TXN9429XWorld Missions Outreach · Brownsville, TXN942AZAz2025 LLC · Miami, FLN942FAPropability One LLC · Daytona Beach, FLN942JMPogany Steve C · Chugiak, AKN942SAWalker John A · Kotzebue, AKN942SMMackie Jonathan M · Manistique, MIN942XAClymer Jordan · Cape Canaveral, FL
Back to AD 79-10-14 R1