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.
N736LXTaylor Tom M · Tulsa, OKN736MC3 Pandas LLC · Farmington, NMN736MDBrown Tyler Cooper Trustee · Anchorage, AKN736MFTurnagain Airventures LLC · Anchorage, AKN736MKDavis Rodger C · Anchorage, AKN736MLH & L Acquisitions LLC · Flushing, MIN736MNSeidler Matthew J · Anchorage, AKN736MPDarby Air Ltd · Lincolnshire, ILN736MTLowe John H · Tifton, GAN736MVMyers Aviation Inc · Oshkosh, WIN736MWWestern Radio Services Co · Prineville, ORN736MYLandry Cheryl A · Mendon, MAN736NCGully Justin T · Anoka, MNN736NEMahoney Daniel P III · Locust Grove, VAN736NFFhr Inc · Honolulu, HIN736NHCi Aviation LLC · Broadview Heights, OHN736NKMaine Air Physician Services LLC · Machias, MEN736NNM2 Aviation LLC · White Lake, MIN736NPMbn Leasing LLC · Dover, DEN736NQAs In The Key Aviation LLC · Marathon, FLN736NWG Force LLC · Las Vegas, NVN736NYTerry Mark Benjamin · Henderson, NCN736NZColey Steven J · Baker City, ORN736PBWoods Joyce M Trustee · Albuquerque, NMN736PCMoore Glen O · Carson City, NVN736PDMiner'S Outdoor Adventures LLC · Hermantown, MNN736PEBohannon Ronald D · Newburgh, INN736PHReynolds Thomas J · Dillon, MTN736PKA&R In The Clouds LLC · Myrtle Beach, SCN736PLSims Charles R Jr · Tuscumbia, ALN736PMBennett James P · Milford, DEN736PPLuksch Daniel C · Murfreesboro, TNN736PQRegistration Pending · John Day, ORRegistration pendingN736PRM3 Aviation LLC · Wausau, WIN736PWTheno Steven M · Coupeville, WAN736PYTurbine Financial Group LLC · Ogden, UTN736QAQuintana Cesar A · Sunny Isles Beach, FLN736QBHambrick Joseph G · Carthage, TXN736QCKirtland Aero Club · Kirtland Afb, NMN736QFWilliams Mitchell L · Chickasha, OKN736QGG&M Aircraft Inc · Wheat Ridge, CON736QNSkjonsberg Robert A · New Effington, SDN736QSWerme Eric Brian · King George, VAN736QYWanken Troy F · Shelby, MTFirst renewal noticeN736RCAtwood William E · Millersville, MDN736RFBiz Flyers LLC · Great Falls, MTN736RHJabavu Aviation LLC · Cedar Hill, TXN736RKRegistered aircraftN736RPExtter Aviation LLC · Parker, CON736RRWatts Glenn L · Anchorage, AK
Back to AD 79-10-14 R1