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

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

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.

N7276XEvv 150 LLC · Evansville, INBuilt 1961 · S/N 15059376 N72775Strode Lawrence W · Naknek, AKBuilt 1946 · S/N 9958 N72776Hanson James A · Bandon, ORS/N 9959 N72777Wilk Alan · East Elmhurst, NYBuilt 1946 · S/N 9960 N7277ADrzewiecki Chad M · Cuyahoga Falls, OHBuilt 1952 · S/N 29377 N7277SMarkland Benjamin Harrison · Lehigh Acres, FLBuilt 1967 · S/N 15067977 N7277TStrehler Stanford L · League City, TXBuilt 1959 · S/N 46877 N72789Dornseif Keith · Merrillville, INBuilt 1946 · S/N 9975 N7278TChudy Daniel B · Yucaipa, CAS/N 46878 N72791Anderson Wayne G · Tehachapi, CAFirst renewal noticeBuilt 1946 · S/N 9977 N7279AGoerger Allan E · Barney, NDBuilt 1956 · S/N 29379 N7279GMartin Rick · Rindge, NHBuilt 1973 · S/N 15074633 N7279SLee Peter Joohak · Irvine, CABuilt 1967 · S/N 15067979 N727BSHorvath Andrew J · Winnsboro, SCBuilt 1966 · S/N 15064667 N727DBKeating John C · Prosper, TXBuilt 1954 · S/N 18-4119 N727HMPatterson Casey Paul · Kinston, ALS/N 15066715 N727KDReich Brad Roy · Rohnert Park, CAS/N 17254281 N727LCBurmaster Christopher R · Murfreesboro, TNBuilt 1966 · S/N 17254788 N727ZTeam Alaska LLC · Anchorage, AKBuilt 1953 · S/N 25542 N727ZGNelson Poultry Farms Inc · Manhattan, KSBuilt 1961 · S/N 17248125 N72800Roberts Donald W · Valley Grande, ALBuilt 1946 · S/N 9986 N72801Brink Daniel · Florence, ALBuilt 1946 · S/N 9987 N72803Cotton Norman E · Carmel, CABuilt 1946 · S/N 9989 N72804Covenant Security Svcs Psp · Decatur, TXBuilt 1946 · S/N 9990 N72808Cutter Anthony · Corning, CABuilt 1946 · S/N 9994 N7280AWarren Holland S · Princeville, ILFirst renewal noticeBuilt 1956 · S/N 29380 N72812Wooley Michael W · Navarre, FLBuilt 1946 · S/N 9998 N7281AWindsock Capital LLC · Bertram, TXBuilt 1956 · S/N 29381 N7281TBreier Clifford G · Dardanelle, ARBuilt 1959 · S/N 46881 N7281XBas Part Sales LLC · Greeley, COBuilt 1961 · S/N 15059381 N72826August Aero LLC · Kalispell, MTS/N 10012 N72827Registration Pending · Winnsboro, SCRegistration pending, pending cancellationBuilt 1946 · S/N 10013 N7282GDurley Randal W · Talladega, ALFirst renewal noticeBuilt 1973 · S/N 15074634 N7282MDom Michael R · Kingman, AZRegistration expired, pending cancellationBuilt 1958 · S/N 55582 N7282SDavis Patrick I · Acampo, CABuilt 1967 · S/N 15067982 N72831Huff Tony D · Luthersville, GABuilt 1946 · S/N 10017 N7283GPetersen Conrad H · Kenmare, NDBuilt 1973 · S/N 15074635 N7283SMiller Bambi · Lee, NHS/N 15067983 N72845Alexandrov Boyan · Reno, NVBuilt 1946 · S/N 10032 N72848Erker Quade J · Roggen, COBuilt 1946 · S/N 10035 N7284MColeman Douglas A · Hubbard, ORBuilt 1958 · S/N 55584 N72851Milton William H · Amsterdam, NYBuilt 1946 · S/N 10038 N72853Day Michael J Trustee · Cedar Key, FLBuilt 1946 · S/N 10040 N72854Dupont Michael R · East Taunton, MABuilt 1946 · S/N 10041 N72856Orme John Robert II · Flushing, MIBuilt 1946 · S/N 10043 N7285MLefritz Richard A · Welches, ORFirst renewal noticeBuilt 1958 · S/N 55585 N7285SHenry Mark A · Dickinson, TXBuilt 1967 · S/N 15067985 N7285XDover Rod S · Goldendale, WABuilt 1961 · S/N 15059385 N72860Woodside Nicholas · Johnson City, TNBuilt 1946 · S/N 10051 N72862Registration Pending · Ozark, ALRegistration pending, pending cancellationS/N 10053

Back to AD 94-05-05 R1