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

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.

N4983RAmerican Flight Museum · Topeka, KSS/N 17256337 N4984ERay L Ender · San Marcos, TXBuilt 1946 · S/N 10588 N4984HWirtz Chadwyck Montford Bennett · San Jose, CABuilt 2008 · S/N CC11-00081 N4985HHinkle Jason D · Cavalier, NDBuilt 1948 · S/N 11-853 N4985MAerial Crop Care Co · Hebron, NDS/N 11-472 N4985RUnited States Air Force Owner · Clovis, NMBuilt 1967 · S/N 17256339 N4987HSmutny John G · Auburn, WABuilt 1948 · S/N 11-870 N4987RUnited States Air Force Owner · Offutt Afb, NEBuilt 1967 · S/N 17256341 N4988MSatreaas Kenneth A · Verona, NDBuilt 1948 · S/N 11-476 N4989RLansing Community College · Mason, MIBuilt 1967 · S/N 17256343 N498AKThompson James A · Ketchikan, AKBuilt 1971 · S/N 15072505 N4990RSmith Joshua B · Kenai, AKBuilt 1967 · S/N 17256344 N4991BStapleton Kenneth E · Nocona, TXBuilt 1965 · S/N 17252588 N4991HFaber Elgin J · Havre, MTBuilt 1948 · S/N 11-884 N4992HJaeger Bruce C · Hebron, NDBuilt 1948 · S/N 11-887 N4995HPeterson Ronald W Trustee · Mitchell, SDBuilt 1948 · S/N 11-886 N4997HBridgewater Benjamin J · Whitefish, MTBuilt 1949 · S/N 11-879 N4997MNiner-Niner-7-Mike LLC · Palmer, AKBuilt 1948 · S/N 11-485 N4998HBartosh Jared F · Carthage, MOBuilt 1949 · S/N 11-893 N4999VMulhern Jeanette Y · Santa Rosa, CABuilt 1959 · S/N 25609 N499CCRegistered aircraftBuilt 2012 · S/N CC11-00089 N499TTMackentepe Zandra Paige · Vinemont, ALS/N 4664 N499WTHagenbrock Scott L · Celina, TXBuilt 1966 · S/N 15065171 N49CKSchels Carl K Jr · Eagle River, WIBuilt 2012 · S/N 6733090 N49CPShenandoah Aviation LLC · Middletown, VABuilt 1953 · S/N 25782 N49CWCyrier John P · Lockhart, TXBuilt 1977 · S/N CW-77-1001 N49ECLovelady David D · Canton, TXBuilt 1949 · S/N 18852 N49FKMcdonell Charles T · Ahwahnee, CAS/N S9412-0069 N49GBloemker Edward L · Fremont, NEBuilt 1946 · S/N 426 N49KPPeterson Kerry J · Toston, MTBuilt 2021 · S/N L-041 N49PRFurstenau Brock A · Tilden, NEBuilt 1949 · S/N 11-1007 N49SPKaiser James · Fond Du Lac, WIBuilt 1977 · S/N 999 N49WMGraupman Gerald A · Chicago, ILBuilt 1949 · S/N 15263 N49WXMason County Aero Club · Ludington, MIBuilt 1968 · S/N 15068744 N49XXMisiti Gary A Jr · Etters, PABuilt 2019 · S/N 75-8667 N4GMGarriga Miguel A · Stevensville, MDBuilt 1975 · S/N 237 N4JRN4jr LLC · Columbus, MSS/N 15064844 N4LRGreen Mark · Killeen, TXS/N 2002 N4NN Flight LLC · Kenedy, TXBuilt 1970 · S/N 1 N4PRAlderman David D · Portland, TNBuilt 1952 · S/N 18-1828 N4QLumpkins Robert W · Laconia, NHBuilt 1949 · S/N 18778 N4RLLeblanc Hazel J · Westminster, MAS/N RL-1 N50000White Barry E · Abbeville, SCS/N 17250145 N50004Nichols Jonathon L · Toney, ALBuilt 1968 · S/N 15069001 N5000AOzment Dennis W · Palmyra, MOBuilt 1955 · S/N 28000 N50010Sawalha Malik · Arlington, TXBuilt 1968 · S/N 15069007 N50012Barnett Russell L · Ozark, MOBuilt 1968 · S/N 15069009 N50014Hertneck Robert W · Lumberton, NJBuilt 1968 · S/N 15069010 N50019Rozier Randall S · Fairbanks, AKBuilt 1968 · S/N 15069014 N5001ADavis Anthony S · Homeland, CABuilt 1955 · S/N 28001

Back to AD 94-05-05 R1