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.
N9741AHelzer Michelle A · Canby, ORN9741FAa-Aero Inc · Fairfield, NJN9741XHalbert Larry E · Jacksonville, FLN97428Right Wing Aviation LLC · Fort Wayne, INN9742BHarp Aviation LLC · Flemington, NJN9742HSingularity - Intelligence Amplified LLC · Conesus, NYN9742VN9742v LLC · Ord, NEN97433Menyhay William Csaba · Clovis, CAN97435Wipaire Inc · South Saint Paul, MNN97437Carr Jeffrey A · Worthington, KYN9743AYokom James C · Wichita, KSN9743BVinson Paul E DBA · Gainesville, GAN97443Miller Charles L Jr · Eunice, LAN97446Mpm Wizard Enterprise LLC · Hawthorne, CAFirst renewal noticeN9744AKahrs Andrew J · Bainbridge Island, WAN9744DTom Wood Aviation Inc · Fishers, INN97452Taylor Michael Riding · Friday Harbor, WAFirst renewal noticeN97453Stofer William B · Warsaw, INN97456Harrington Co · Butte, MTN97459Christiansen Aviation LLC · Wilmington, DEN9745TOwens Edward W · Raymore, MON97465Civil Air Patrol Inc · Maxwell Afb, ALN97467Kg Rentals LLC · Edmond, OKN97469Wooten James E · Avinger, TXN9746APetey LLC · Bozeman, MTN9746BRegistration Pending · Middletown, DERegistration pendingN9746XAgent West Insurance Inc · Hurricane, UTN9746YAircraft Holding Solutions LLC Trustee · Newark, DEN9747GPavlu Aerial Spraying LLC · Ness City, KSN9747TMapes James R · Ellensburg, WAN97485Strong Neil E · Pittsburg, TXN97487Bruns Gregg R · West Chester, OHN97489Neron II LLC · Lewes, DEN9748AJuhl Amanda · Centennial, CON9748GKlamar Spraying Inc · Gatzke, MNN9748ZKerr Kenneth E · Bakersfield, CAN9749BLee Norman S · Green Valley, AZN9749G3 B Farms Inc · Pinetown, NCFirst renewal noticeN9749XNeal Daniel A · Winchester, TNN974BCL & W Aircraft Investment LLC · Homestead, FLN974CAFranks Gary W · Bolivar, MON974DBPhoenix East Aviation LLC · Daytona Beach, FLN974PCMontana Bizjets LLC · Missoula, MTN974RCRafael Cisneros LLC · Wilmington, DEN974SFAerospace Trust Management LLC Trustee · Wilmington, DEN974SGWalters Patrick W · Tallapoosa, GAN974SPTexas State Technical College · Waco, TXN974TASky Peak Aviation LLC · Los Angeles, CAN974THRidgeline Assets LLC · Wilmington, DEN97503Mercury International LLC · Cheyenne, WY
Back to AD 79-10-14 R1