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.
N9507ALott William F Jr Trustee · Oklahoma City, OKN9507BHanderson Ronald Jr Sr · Sitka, AKN9507LBatra Sanjeev · Roseville, CAN9508BRegistered aircraftN9508WUniversity Of Alaska Anchorage · Anchorage, AKN9509GMid Continent Aircraft Corp · Hayti, MON9509TKline John C · Wolcottville, INN9509XHilliard Keith B · Van, TXFirst renewal noticeN950ACRed Carpet Aviation LLC · Carlsbad, CAN950CPCivil Air Patrol · Maxwell Afb, ALN950DRRjc Skyhawk LLC · Middletown, DEN950HPKansas Highway Patrol · Topeka, KSN950LPAmeriflyers Of Texas Inc · Addison, TXN950MEN950me LLC · Manassas, VAN950MGDurante Salvatore · Oro Valley, AZN950SRAcme Aero LLC · Kingman, KSN9510HRegistered aircraftN9510JOrange County Mosquito Control District · Orange, TXN9510LCivil Air Patrol Inc · Maxwell Afb, ALN9510XWillett Michael J · North Little Rock, ARN9511BRadford Kenneth J Jr · Chugiak, AKN9511DEglin Aero Club · Eglin Afb, FLN9511GBurdette Ernest L · Pass Christian, MSN9511RBrewer William B · Fairbanks, AKN95129Texas State Technical College · Waco, TXN9512ACook Timothy L · Oklahoma City, OKN9512FGeorge'S Aviation Services Inc · Honolulu, HIN9512HTracy Patrick J · Maddock, NDN9512LKreykes K Douglas · Greeley, CON9512XSwagerty Michael P · La Mesa, NMN9512YPalmer George J III · Orlando, FLN9513BLong Michael A · Grand Lake, CON9513GThomas David · Boise, IDN9513HHigh Flight Academy LLC · Allison Park, PAN9514GP51d Mustang LLC · Bigfork, MTN9514HFrerichs John E · Gurley, ALN9515BGrason Aviation LLC · Appleton, WIN9515GRegistration Pending · Kenai, AKRegistration pendingN9515QVictory Aviation Club Inc · Hamilton, OHN9515RCunningham Michael K · Pinebluff, NCN9515SKingsky Flight Academy LLC · Lakeland, FLN9515XJones Jeffrey A · Rehobeth Beach, DEN9516AHogan Robert P · North Pole, AKN9516JEastern Kentucky University · Richmond, KYN9516WRingco Aviation LLC · Oklahoma City, OKN9516XZeroone Easy Group Inc · Winchester, KYN9517HPlane Solutions LLC · Kalispell, MTN9517TSteele Cody T · Polson, MTN9517XKelley James E · Kennewick, WAN9518AFinney Kevin Anthony · Hawthorne, FL
Back to AD 79-10-14 R1