AD 94-05-05 R1
Registered aircraft · 26,232
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N6672EKing Aubrey R · Salinas, CAN6672FRodriguez Cory Omarr · Abilene, TXN6672SPikul Daniel J · Monson, MAN66730Glau John E · Centennial, CON66736Klein Todd · Winston Salem, NCN66738Irvin Bradley A · Lula, GAN66739Airgo Inc · Centralia, ILN6673ASearson Jason C · Newton, NCN6673EMiller Daniel F · Grain Valley, MON6673FKysar Ian R · Battle Ground, WAN66745H T Productions Inc · Grayling, MIN66748Skypark Inc · Wadsworth, OHN6674AThomas Craig S · Salem, ORN6674FBon Investment Holdings LLC · Zephyrhills, FLN6674GJoe Dory Aviation LLC · Caldwell, IDN66751Talmage Timothy A · Azle, TXN66753Andreasen Trevor C · Springville, UTN66755Fischer A Edward Jr · Hampstead, NHN66756Listzwan James · High Springs, FLN66758Dahlberg James C · Ogilvie, MNN6675ETornquist Robert John Jr · Turlock, CAN6675FCommercial Center Inc · Wilmington, DEN6675TYoung Dan J · Norwalk, IAN66768Ludemann 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, IDN6677EEmery Edward L · Marysville, WAN6677TStewart Greg Lee · Bottineau, NDN66780Keenan Jim F · Neenah, WIN66781Strong Mack A · Coral Springs, FLN66785Destefano Patrick S · Bryan, TXN66786Gibb Bryce M · Portland, TXN66790Logan Dan P · Gilliam, LAN6679SCampos Katherine · Tallahassee, FLN667PBButzin Paxton E · Wild Rose, WIN6680TParsons Joshua A · Hollis Center, MEN6681ACarignan Armand R · Hooksett, NHN6681EFoisy Douglas · Burleson, TXN6681GMoore Joseph L · Hesperus, CON6683EBergeson 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, MI
Back to AD 94-05-05 R1