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.
N6675FCommercial Center Inc · Wilmington, DEN6675MMorrissette Todd · Buxton, MEN6675TYoung Dan J · Norwalk, IAN66764Cuttler Lloyd · Carabaset Vly, MEN66765Kalba Shaun B · Pleasant Valley, NYN66768Ludemann John K · Enfield, CTN6676FCampbell J R Jr · Bell, FLN6676GChen Hong · Independence, ORN6676TCash W Duane · Fairfield Bay, ARN66774Kilo Lima LLC · Hicksville, NYN66776Broherd James · Natalia, TXN66777Lennon Bobby M · Whiteville, NCN66779Blinn Philipp Randy · Priest River, IDN6677BHess Chad · Boise, IDN6677EEmery Edward L · Marysville, WAN6677HPeterson Robert E · Richland, WAN6677RTre Aviation Corp · Wilmington, DEN6677TStewart Greg Lee · Bottineau, NDN6677XMuhlenbrock Guillermo Rene Jr · Las Vegas, NVN66780Keenan Jim F · Neenah, WIN66781Strong Mack A · Coral Springs, FLN66785Destefano Patrick S · Bryan, TXN66786Gibb Bryce M · Portland, TXN6678XKinman Kary Wade · Panama City Beach, FLN66790Logan Dan P · Gilliam, LAN6679SCampos Katherine · Tallahassee, FLN667ARRegistered aircraftN667BCWithrotor Aviation Inc · Lakeview, ORN667BLClover Park Technical College · Lakewood, WAN667CPCivil Air Patrol · Maxwell Afb, ALN667EREmbry-Riddle Aeronautical University Inc · Prescott, AZN667PBButzin Paxton E · Wild Rose, WIN667SPHindi David · Cupertino, CAN667WBMcleod Patrick J · Overgaard, AZN6680BBush Douglas B · Santa Rosa Beach, FLN6680EPrax Philip · Fairbanks, AKN6680MMcshane Shannon K · Alamo Heights, TXN6680TParsons Joshua A · Hollis Center, MEN6681ACarignan Armand R · Hooksett, NHN6681EFoisy Douglas · Burleson, TXN6681GMoore Joseph L · Hesperus, CON6682XDuff John W · Alligator, MSN6683EBergeson John S · Rhome, TXN6683GPardee Gary D · Buckley, WAN6683SWingsofdawn LLC · East Greenwich, RIN6683THecker Darin S · Grants Pass, ORN6684ASchumacher Leroy H · Beach City, OHN6684ERound Engine Aero · Nashville, MIN6684GReeder Brenton Lamar · Beacon, NYN6684MMlynarczyk Stanley · Darien, IL
Back to AD 79-10-14 R1