AD 94-05-05 R1
Registered aircraft · 26,231
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.
N2901VGensrich Lee O · Hatton, NDN2902DRoss Charles E · Tuscola, TXN29036Kubecka Daniel P · Texas, TXN2903NPatrick Steven B · Glencoe, CAN2903VRegistration Pending · Bellevue, WARegistration pendingN2904DBeckens Scott A · Sodus, NYN2904NEvolution Aircraft Inc · Zephyrhills, FLN2904VGreen William D · Fairbanks, AKN2905NBrowning IV Lonnie O · Allendale, SCN2905SCole Ezra L · Gentry, ARN2905UKear Edward B · Bonita Springs, FLN2906DKennedy Ken · Lubbock, TXN2906NSchulte Steven P · Rocklin, CAN2906ULynch Lawrence C · Ladson, SCN2907NLawrence Doyle D · Dallas, TXN2907UServer William F · Sterling, MIN2908JBranton Hewett · Nashville, TNN2908NFodie Kerry J · Aurora, ORN2908SSloan Paul · Escondido, CAN2909SFatla Gregory F · Hixton, WIN2910DDomke Daniel Carl · Anchorage, AKN2910JWeldy Mark L · Etna Green, INN2911UNight Sky LLC · Canton, SDN2911VRegistration Pending · Bellevue, WARegistration pendingN2912DSatanta Flying Service Inc · Satanta, KSN2912SWard Ascher · Oxnard, CAN2913DSale Reported · Nome, AKSale reportedN2913JMulti Engine Training Co Inc · Tuttle, OKN2913KSilverman Phillip E Trustee · Fullerton, CAN2913SMartin Richard E · Palmyra, WIN2914JMaverick Aviation Holdings LLC · Sheridan, WYN2914USethi Inderdeep S · Tracy, CAN2915DUlrich Craig T · Albany, ORN2915HGregory Vernon L · Swansea, SCN2915NN2915n LLC · Dillon, MTN2915SKoch Kenneth Scott · Coolidge, AZN2916DWatkins Brad D · Roseburg, ORN2916UJohnson Mark D · Camano Island, WAN2917DYoung Michael E · Munroe Falls, OHN2917JKnoll David Alexander · Godwin, NCN2917SItz LLC · Lusby, MDN2917UCelebrate Freedom Foundation · West Columbia, SCN2918JNiemann Benjamin W · Welton, IAN2918SAbove All Aviation Inc · Goleta, CAN2919SJust Plane Corp · Kokomo, INN291AMBeck Joseph P III · Pollock, LAN291YASherman Jason Bradley · Indianola, IAN2920DYarbrough Deborah C · Somerville, TNN2920JRegistration Pending · Powell Butte, ORRegistration pendingN2920SLea Nathanael E · Olalla, WA
Back to AD 94-05-05 R1