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.
N736FYPhydeaux Aviation Ltd · Spartanburg, SCN736GAPlane Jane Aviation LLC · Sylvania, GAN736GBSilva Monico · Albuquerque, NMN736GCSilvers Morris · Burnsville, NCN736GDPactolus Investments LLC · Blounts Creek, NCN736GGLedocq Melissa A · Green Bay, WIN736GHTriple R Flying · Monticello, IAN736GJRyan Transfer Inc · Tilden, NEN736GKOrten Steven S Md · Dallas, TXN736GNMorrison Scott W · Kokomo, INN736GUFaria Farms Inc · Tipton, CAN736GVChristiansen Drilling Inc · Ely, NVN736GWMartin Stephen E · Pampa, TXN736GZJust US Air LLC · Bradenton, FLN736HATurner Daniel A · Paragould, ARN736HBZero-To-1500 LLC · Tacoma, WAN736HDGuthrie John Alex · San Ramon, CAN736HGMcclure Richard A · Victoria, TXN736HMAir Force Academy Aero Club · Usaf Academy, CON736HNRegistration Pending · Orange Grove, TXRegistration pendingN736HSHodgskiss Ben · Choteau, MTN736HWInvestair LLC · Conway, ARN736HZBird Chad W · Santa Ana, CAN736JESylvan Air Associates LLC · Lapeer, MIN736JFHartsuyker David L · Jackson, CAN736JHLloyd Stephen C · Erie, CON736JKMcfeaters Ryan C · Madisonville, TNN736JQRaven Limited · Seattle, WAN736JRMckibben Claude · Rochelle, ILN736JTRose Chris W · Rochester, NYN736JVRegistered aircraftN736JWHutcherson David R · Gretna, VAN736JYBorreson Anthony · Mariposa, CAN736KCGreen Robert W · Santa Barbara, CAN736KDAmts LLC · Pleasanton, CAN736KERegistration Pending · Cozad, NERegistration pendingN736KFEason Richard O · Orono, MEN736KNTurbine Financial Group LLC · Ogden, UTN736KPSutton Aircraft Salvage LLC · Palmer, AKN736KSRigfuel LLC · Eureka, MTN736KYSicheneder Scott A · Wasilla, AKN736LBSkyraider Aero Club · Spokane, WAN736LDSteinmeyer Peter A · Arvada, CON736LGM & R Aviation LLC · Fairview, ORN736LHDdjrrm Enterprises LLC · Plainfield, INN736LLSmith Matthew R · Thomaston, GAN736LMRaducu Radu · Bismarck, NDN736LPAlpha Kilo Aviation LLC · Wasilla, AKN736LVEggleston Kenneth W · Bethel, AKN736LWDrr Boonville LLC · Boonville, NY
Back to AD 79-10-14 R1