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.
N9395BChristiansen Aviation LLC · Wilmington, DEN9395HInosculation Air LLC · Summerville, SCN9395NUnited States Department Of Interior · Boise, IDN9395XCoyote Air · Austin, TXN9396AFortune Michael W · East Dublin, GAN9396BRhyshek John C · King Salmon, AKN9396HHaley Robert Jay · Livermore, CAN9396UMullen Randy R · Pasco, WAN9396XGonzalez Leopoldo · Laredo, TXN93974Just Plane Stupid LLC · Loveland, CON9397HFlight World Inc · San Juan, PRN9397UWelch Kerry D · Alpine, UTN9398BBishop Daniel R · Bettendorf, IAN9398CHolden Daniel N · Anacortes, WAN9398UShouling & Philip Enterprise · Lancaster, CAN9398XRegistration Pending · Chillicothe, OHRegistration pendingN9399BSamoilenko Sergey V · Hillsborough, NCN9399CHansen Sean J · Anchorage, AKN9399E9 Echo LLC · Muskogee, OKN9399MGrant Aviation Inc · Anchorage, AKN9399XStorm Flying Service LLC · David City, NEN939AFAmeriflyers Of Texas Inc · Addison, TXN939DJJaffray Management LLC · Green Cove Springs, FLN939RLHintzsche Roger E Trustee · Dekalb, ILN939SPAero Aircraft 12 LLC · Jacksonville, FLN93BZMoreno Joseph L · San Diego, CAN93ETGhatan Farhad · Friday Harbor, WAN93FMAms Aviation LLC · South Bend, INN93HFHeritage Asset Leasing LLC · Ronkonkoma, NYN93HPAxe Capitol Inc · Lake City, FLN93JESibora Group LLC · Gilbert, AZN93JSNeptune Aviation Services Inc DBA · Missoula, MTN93KKMonmouth Area Flying Club · Lakewood, NJN93LSutton Aircraft Salvage LLC · Palmer, AKN93MBNorthwoods Air LLC · Orono, MEN93MMChristenson Robert E · Anacortes, WAN93PSVanderflute Scott L · Lakewood, WAN93QDurtschi James Werner · Sisters, ORN93SDRealtyaviation LLC · Key Largo, FLN93THAir Chief LLC · Granbury, TXN93TPBagley Corydon S · Holladay, UTN94000Champion Aircraft LLC · Valdosta, GAN9400EVan Anda Aviation LLC · Apopka, FLN9400GMurphy James T · Nashville, TNN9400HRoach John C · Lawrenceburg, KYN9400LMerino Cesar · Washington, DCN9400XWilliams Dutch R · Mohave Valley, AZN94018Northern Air Transport Inc · Mora, MNN9401ASwinney Vincent F · Waldport, ORN9401GNoble Cody Trustee · Ardmore, OK
Back to AD 79-10-14 R1