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.
N4655XJp Aero Holdings Inc · Carson City, NVN46563Stephen Iain D · Anchorage, AKN46567Hullquist Claude G · Ringgold, GAN4656CHavener Hunter W · Chittenango, NYN4656FCrowley Thomas Bannon III · Tigard, ORN4656LRegistered aircraftN4656VWest Riverbend LLC · Washington, MON46570Nied Rossana C · Duarte, CAN4657BBeam Gregory E · Anchorage, AKN4657CHayden Dale G · Wisconsin Rapids, WIN4657FDoxsee Arthur B · Bennington, VTN4657GFlorida Flight Training Center Inc · Venice, FLN4657QSaddle Mountain LLC · Cave Creek, AZN4657XVan Buskirk Samuel Victor · Valdez, AKFirst renewal noticeN46581Gatlin Jason B · Athens, ALN46584Rizzo Joseph V · Binghamton, NYN46586Hardin Thomas E · Bardstown, KYN4658ALerner Michael M · Tehachapi, CAN4658FSedrel Steven M · Sparks, NVN4658GGlobal Aviators Academy Inc · Claremont, CAFirst renewal noticeN4658LHarrison Doug A · Yellville, ARN46593Grupo Cuaahtemoc LLC · Canutillo, TXN4659CBeesley Cattle Company LLC · Port Gibson, MSN4659G4659g LLC · Wheeling, ILN4659LTalcorp Inc · Justin, TXN4659QN4659q Corp · Papillion, NEN465AMN465am LLC · Hollis, NHN465CAAtp Aircraft 4 LLC · Wilmington, DEN465CGApogee Air LLC · Newark, CAN465CMUniversity Of Central Missouri · Warrensburg, MON465CTMatter Terrence K · Reno, NVN465EPRainier Flight Service LLC · Renton, WAN465HMMorse Don W DBA · Priest Lake, IDN465QSchmidt Fred P · Fenton, MON465TByrds Wholesale Inc · Clayton, NCN46600Baker Matthew C · Maryville, MON46601Skywarrior Flight Training Inc · Pensacola, FLFirst renewal noticeN4660AConnealy Air LLC · Whitman, NEN4660BEllison Orlo T · Broomfield, CON4660CToudouze John M · La Vernia, TXN4660GAdvantage Aviation Inc · Palo Alto, CAN4660KFoster Gary Paul · Willow, AKN4660LSitton Wyatt D · Washtucna, WAN4660NCasey Kellie M DBA · Fort Worth, TXN4660XRegistered aircraftN46612Dugger Joey D · Nine Mile Falls, WAN46613Mad Cap Inc · Smithfield, RIN46615Lindsay William G · Santa Paula, CAFirst renewal noticeN46616Koubsky Richard L · Hollywood, SCN4661AOlson Eric T · Hudson, WI
Back to AD 79-10-14 R1