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.

N3019XSkyy King LLC · Helena, MTBuilt 1966 · S/N 15064419 N301GWCollege Of Missionary Aviation Inc · Keystone Heights, FLBuilt 1969 · S/N 15071678 N301PFLahm David K · Cozad, NEBuilt 1975 · S/N 15076830 N3020NShuster David M · Estero, FLBuilt 1947 · S/N 13278 N3020UKelly Ho-Montoya Insurance Group LLC · Wichita Falls, TXBuilt 1963 · S/N 17250620 N3020XLima 2 Aviation Of Mississippi LLC · Bogue Chitto, MSBuilt 1966 · S/N 15064420 N30210Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1940 · S/N 4693 N3021GHamboys Aviation LLC · Hermitage, PAS/N 5714 N3021JDuffy William B · Denton, TXBuilt 1965 · S/N 15061121 N3021SCollett Danny W · Stewart, TNBuilt 1967 · S/N 15066921 N3021XMay'S Welding Service Inc · Cotulla, TXS/N 15064421 N3022AReese Brandon A · Bend, ORBuilt 1953 · S/N 25666 N3022GRokicki Stephen M · Corrales, NMFirst renewal noticeBuilt 1960 · S/N 5715 N3022HScheidel Aaron J · Pleasant Grove, CAS/N 3647 N3022SMcnulty Bobby J · Luling, LABuilt 1967 · S/N 15066922 N3022VRetroair Restoration LLC · Big Lake, AKBuilt 1974 · S/N 15076354 N3022XCintim LLC · Carrabelle, FLS/N 15064422 N3023APhillips Danny W · Jefferson, TXBuilt 1953 · S/N 25667 N3023GPollack Jack · Scottsdale, AZS/N 5716 N3023SSynnes Dale C · Santa Paula, CABuilt 1967 · S/N 15066923 N30244Clarkson Darren E · Phoenix, AZBuilt 1940 · S/N 4724 N3024XDavis James M · Tuscaloosa, ALBuilt 1966 · S/N 15064424 N30256Frickel Richard L · Bristow, NEBuilt 1940 · S/N 4731 N3025HBrandt Merle G · Potomac, ILBuilt 1946 · S/N 3650 N3025SHummer Bryant C · Garden Plain, KSBuilt 1967 · S/N 15066925 N3025UEddy Bruce A · Winfield, ALBuilt 1963 · S/N 17250625 N30263Pullon Michael · Roebuck, SCBuilt 2011 · S/N 16200092 N30265Corsair Aviation LLC · Pacoima, CAS/N 16200093 N30267Registration Pending · Las Cruces, NMRegistration pendingBuilt 2008 · S/N LA 9 N3026APowell Alvin L · Caldwell, IDS/N 25670 N3026GVaughn Edward J · Wellston, OKBuilt 1960 · S/N 5720 N3026HOstergaard David E · Keithville, LABuilt 1946 · S/N 3651 N3026JRoberts James D Trustee · Omaha, NEBuilt 1965 · S/N 15061126 N3026SSolewin Kimberly M · Christoval, TXBuilt 1967 · S/N 15066926 N3026VNew Mexico Flying Eagle Inc DBA · Tucson, AZS/N 15076355 N30270Luminair Inc · Ashland, ORBuilt 1940 · S/N 5-162 N30279Smith Daniel Bruce · Boonville, NCBuilt 1940 · S/N 5163 N3027GGregory Vernon L · Swansea, SCBuilt 1960 · S/N 5722 N3027HHeilmann Charles E · Millwood, WVBuilt 1946 · S/N 3652 N3027XSchneider Benjamin J · Wheeling, WVBuilt 1966 · S/N 15064427 N3028GZagst Jedediah · Frankston, TXBuilt 2011 · S/N 16200095 N3028VChildress Sam · Weatherford, TXBuilt 1974 · S/N 15076357 N3028XFicken Jerome L · Cedar Hill, MOBuilt 1966 · S/N 15064428 N30295Sipple Ronald W Jr · Gardner, KSBuilt 1940 · S/N 4770 N30296Chrisaire LLC · Orange, CAS/N 16200096 N3029DKoontz Gregory L · Crossville, TNBuilt 2011 · S/N 16200097 N3029FM&L Flight Inc · Newcastle, WABuilt 2011 · S/N 16200098 N3029JSorrells Brandon L · Yuma, AZBuilt 1965 · S/N 15061129 N3029SBlawusch Richard K · Waterloo, WIBuilt 1967 · S/N 15066929 N3029VFlyt LLC · Madison, MSS/N 15076358

Back to AD 94-05-05 R1