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.
N5390RSmith James H · Fordyce, ARN5390TBakker Johanna · Spokane, WAN5390VSpringfield Flying Service LLC · Columbia, CAN5391ASingh Amandeep · Stockton, CAN5391DPope James D · Lewiston, IDN5391HHansen Alvin Kent · Winamac, INN5391QMja Aviation LLC · Channahon, ILN5392CMcclintock Jesse H · Camarillo, CAN5392QLatitude Aviation LLC · Cedar Rapids, IAN5392TStarkovich James M · Arlington, WAN5393CPlane Fun Inc Tr Trustee · Snellville, GAN5393NRegistration Pending · Craig, CORegistration pendingN5393TTinseth Lance D Trustee · Highlands Ranch, CON5393VWheeler Seth · Durham, NCN53945Lewis Robert · Chandler, AZN5394CWillie Gary D · Elkader, IAN5394DBruce Gregory L · Yelm, WAN5394TBigler Danny L · Owasso, OKN5394XL K Hollenbeak Logging Inc · Hayfork, CAN5395BRosecrans Robert Michael · Emmett, IDN5395DLindberg Thomas W · Anchorage, AKN5395HHansen James R · Kenmore, WAN5395NDelaware Horizon Properties LLC · Lewes, DEN5395QOwens John C · Mount Carmel, PAN5395VCortez Flying Service Inc · Cortez, CON5396BGreene County Sport Parachute Center Of Ky Inc · Loretto, KYN5396CSmith Richard E · Olympia, WAN5396ESorbi Aviation Inc · El Cajon, CAN5396RPrecocity Academy LLC · Gibsonia, PAN5396TMclaughlin Daniel J · Elbridge, NYN5397CFontana Andrew W · Lake City, MIN5397DRandall William G · Oklahoma City, OKN5397RIowa Lakes Community College · Estherville, IAN5398CRed Rose Flying Club · Spring City, TNN5398TSandstrom Mark · Minot, NDN53996Pea-Wayman Flight LLC · Daytona Beach, FLN5399CPoling Micah D · Gaston, ORN5399DWeeks Patrick · Anchorage, AKN5399EAerocraft LLC · Durango, CON5399JMann Aviation Inc · Long Beach, CAN5399KColemanation Investments LLC · Naperville, ILN539KSKent State University · Stow, OHN539MTFlyboys LLC · Fall City, WAN539MYMiller Aviation LLC · Murfreesboro, TNN539NDAerosim Academy Inc · Sanford, FLN539PBHumphrey Daryle C · Graford, TXN53AAMustang Sally Aviation LLC · Camden, SCN53BWheaton James · Rutherfordton, NCN53ESSpooner Brent · Fulshear, TXN53EURegistered aircraft
Back to AD 79-10-14 R1