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.
N91156Scarlett Ryan Jay · Sparks, NVN91157Garza Aircraft Inc · Harlingen, TXN9115BParker Justin S · Elko, NVN9115THigginbothan Stewart C · Woodbine, GAN9115UWigley Ben F Jr · Huntington, ORFirst renewal noticeN91160Brown Jeffrey C · Saint Augustine, FLN91162Kelley Patrick J · Catawba, NCN9116BS Dacy Enterprises Inc · Harvard, ILN9116GJones Brian E · Painted Post, NYFirst renewal noticeN9116XTaylor Aviation Inc · Fort Benton, MTN91170Paklook Air Inc · Bethel, AKN9117BPartridge John R · Manchester, NHN9117GAndrews Mimi Muldrow · Hilltop Lakes, TXN9117MPettigarrett LLC · Manchester, GAN9117TMichaud Paul K · Forest Lake, MNN9117UBahr Timmy A · Crandon, WIN91183Hatch Hyrum G · Gilbert, AZN9118BCulpeper Aviation LLC · Queen Creek, AZN9118THagen Bruce L · Reeder, NDN9118U9118u LLC · Dover, IDN91190Renfro Michael W · Bethel, AKN91199Olmstead Daniel H · Kimberly, IDN9119ATorraca Peter · New York, NYN9119GWinters Richard Linn · Chandler, AZN911ATW I F A (Washington International Flight Acad) LLC · Gaithersburg, MDN911BWOlsen Garry O · Forest Lake, MNN911EWeiss Elliott · Fresno, TXN911JTSchaefer Kent M · Anacortes, WAN911LAMindy Limited LLC · Muscatine, IAN911MCKing Daddy Aviation LLC · Madison, MSN911MDAirplex Aircraft LLC · Springfield, MON911PBaldwin Andrew W · Lander, WYN9120CFrison Joseph · Milton, WIN9120GRoderi Air LLC · Berlin, MDN9120HKrieg Kristi · Tonasket, WAN9120XStevens Matthew J · Onaway, MIN9121CBowser Justin · Colorado Springs, CON9121HTwenty-One Flyers Inc · Norwalk, CTN91220Wall Christopher Kenneth · Rochester, NYN91221Marvin Ray · Tomahawk, WIN91223Taylor James R · Murfreesboro, TNN91224Peninsula Aero Technology Inc · Kenai, AKN91225Woodaman James G · Pasadena, CAN9122CJohnson Joseph S · Eagle River, AKN9122TWerth Lance C · Johnson Lake, NEN9122XBissell Lee G · Culver, ORN91230Cutting & Sektnan Inc · Mcminnville, ORN91231N91231 LLC · Columbia, MON91236Skylane 73 LLC · Altadena, CAN9123ASale Reported · Draper, UTSale reported
Back to AD 79-10-14 R1