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.
N876SPb Limited LLC · Kalispell, MTN876SHPatton Michael D · Tygh Valley, ORN876SMNathan Smith Ministries · Belmont, NCN876WFries Jeffery A · Paw Paw, MIN8770TNoble Aviators Inc · Kendallville, INN8770XRegistration Pending · Tulsa, OKRegistration pending, pending cancellationN8771SGillette Robin A · Scio, ORN8771XAgainst The Wind Inc · Jasper, TNN8772SMccormick Joel S · Elmwood, ILN8772XSargent Leslie K · Chuckey, TNN8773GWhite Jules W · Wichita, KSN8773URegistration Pending · Scotch Plains, NJRegistration pendingN8773ZPolhamus Mark Trustee · Thompson Falls, MTN8774ZAero Squadron LLC · San Diego, CAN8775BGauger Cody · Edmond, OKN8775XJust Jump Skydiving LLC · Laurens, NYN8775ZB&B Auto Body LLC · Terreton, IDN87767Usda Forest Service Fepp · Malvern, ARN8776QRichardson Thomas R · Valleyford, WAN8777BBurks Danny E · Fordland, MON8778BJohnson Timothy L · Berlin, WIN8778TLogan Ronald Thomas Jr · Newfoundland, PAN8778UWright Penny L · San Francisco, CAN8778ZMartin Seth E · Palmyra, PAN8779BMeyers Jess H · Las Vegas, NVN8779GEga Aero Specialty Services LLC · Beaufort, SCN8779TSkyair Express LLC · Overton, NVN8779XPannell James R · Carrabelle, FLN877AAFlx Flyers LLC · Farmington, NYN877ATAir One Inc · Valparaiso, INN877CBNagaruk Nathan · Nome, AKN877TFMattingly Bruce A · Morehead, KYN8780BHite Douglas T · Frisco, TXN8780UReeves Gary A · Lorimor, IAN8781TFereday Richard R · Mccall, IDN8781UHalsey Gene L · Huron, SDN8781XWinterholler Robert D · Lovell, WYN8781ZHogue Marc · Tempe, AZN8782TGood Altitudes Aviation LLC · Spring Hill, KSN8782XSpo Land And Cattle LLC · Springville, AZN8783BRosine Steven D · Troutville, VAN8783ZAdventure Aircraft And Equipment LLC · Chelan, WAN8784TElizabeth City State University · Elizabeth City, NCN8784UWilson Jacob T · Loma Linda, CAN8784XHubele James R · Independence, ORN8785GPate Robert J · Hilltop Lakes, TXN8785USchoenling Joseph S · Cincinnati, OHN8785ZRegistration Pending · Connell, WARegistration pendingN8786GKellum Roman Micah · Alexander City, ALN8786SJae Grace Elizabeth · Madison, AL
Back to AD 79-10-14 R1