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.
N4674CN&C Enterprises LLC · Vine Grove, KYN4674EMilliken Bradley B · San Mateo, CAN4674UKlein David · Sebastopol, CAN4674XSaunders Christopher · Lehighton, PAN4675CLane Robert W · Palmer, AKN4675ERojo Aircraft LLC · Mesquite, NVN4675XBlalock Merrel K III · Mayflower, ARN4676BRobbins J Putnam · Valparaiso, INN4677CRegistered aircraftN4677LJet Airways Express Inc · Aventura, FLN4677QDahl Larry A · Cogswell, NDN4677XBaird Harvey L · Sharon, OKFirst renewal noticeN4678BKing Paul E · Albany, ORN4678FMullett Sean · Cleveland, TNN4678KGarcia Roberto P · Spring Hill, FLFirst renewal noticeN4678QPrairie Dog Aviation LLC · Sioux Falls, SDN4679AFlying Bulldogs LLC · Joplin, MON4679CDahl Dan P · Wasilla, AKN4679GFlightime Inc · Elkhart, INN4679LFitting Solutions Lc · Chester, NJN4679UNelson Ross R · Menomonie, WIN4679XVentura Joel · Andover, MAN4679YExtreme Air LLC · Cottage Grove, WIN467AT467at LLC · Frankfort, ILN467CMIasco Flight Training Inc · Redding, CAN467DHLopez Floyd W · Arroyo Seco, NMN467ERWingsleasing LLC · Wichita, KSN467QStegner John J · Boonville, MON467TSPsl Surveys · Manassas, VAN4680KIntrepid Red Baron Inc · New Franken, WIN4680LWasilowski Steven P · Elgin, ILN4680UFoster Randy · La Grange, TXN4681FFisher Adam · Corona, CAN4681KBluestone Ryan Joseph · Lake Havasu City, AZN4681LOmer Syeda · Gilroy, CAN4681ZWhite Blaine Scott · Castlewood, VAN4682DBusch Craig D · Green Brook, NJN4682LJones Carl R · Little Rock, ARN4682QHangar 27 LLC · Bountiful, UTN4682UWaddoups Max E III · Palmer, AKN4683GDeichert Ryan L · Bismarck, NDN4683KKrohn Ronald C · Pauma Valley, CAN4683LLawson Seth A · Morgantown, WVN4684AShilanski Micah V · Wasilla, AKN4684LHowell Tyler L · Romoland, CAN4685ARegistered aircraftN4685FRulewicz Dennis G · Jackson, MIN4685LEsquilin Steven C · Poway, CAN4685XFite Robert G · Brookings, SDN4686BThompson Harrison C · Brookings, SD
Back to AD 79-10-14 R1