Skip to content

Registered aircraft · 40,472

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:80-04-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') 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:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  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:80-04-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
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.

N222WGWalker Scott Aviation LLC · Woodward, OKBuilt 1978 · S/N M-2092 N2230TWhite Pelican LLC · Union City, TNBuilt 1971 · S/N 28-7105189 N2230XPoff Matthew W · Miramar Beach, FLBuilt 1979 · S/N 28-7990374 N2232ASummit Air LLC · Clarks Summit, PABuilt 1976 · S/N 28-7690460 N2232BLucky Dog Land Co LLC · Caldwell, IDBuilt 1990 · S/N 512 N2232EPink Skies Inc · Willoughby, OHBuilt 1978 · S/N 17271195 N2232LDodson Jack Yii · Douglasville, GABuilt 1976 · S/N MB-819 N2232NKnoll Guenter Wilhelm · Belton, SCBuilt 1979 · S/N 28-7990283 N2232WJkj Aviation · Wilmington, NCBuilt 1979 · S/N 28-7916334 N2233BRollin Virginie C · Mountain House, CABuilt 1978 · S/N 28-7816598 N2233CFreeland Robert D · Victor, MTBuilt 1978 · S/N 28-7990147 N2233PAeroplanes Over Idaho · Caldwell, IDS/N 23-842 N2233XSpector Arnold · Stamford, CTBuilt 1979 · S/N 28-7990368 N2234FMoore Aviation LLC · Cedar Springs, MIBuilt 1978 · S/N 28-7990207 N2234PDanhauer Jeffrey · Owensboro, KYBuilt 1974 · S/N 761-74 N2235BConner W Larry · Los Lunas, NMBuilt 1978 · S/N 28-7916120 N2235ELivingston Eric L DBA · Winchester, INBuilt 1978 · S/N 17271198 N2235LCarter Dale · Riga, MIBuilt 1976 · S/N M-1905 N2236GParis Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7916215 N2236PCitation X Parts LLC · Liberty, NCBuilt 1956 · S/N 23-845 N2236UPrater Jon A · Palm Coast, FLBuilt 1967 · S/N 475 N2236WMiloud Chadd K · Fort Worth, TXBuilt 1979 · S/N 28-7916337 N2237KCarolina Air LLC · New London, NCBuilt 1978 · S/N 28-7916232 N2237LDeatherage Christina M · Goshen, OHBuilt 1976 · S/N M1885 N2237TSchmelzle Michael O · Shrewsbury, MOBuilt 1979 · S/N 28-7916302 N2238GRupp Aviation LLC · O Fallon, MOBuilt 1979 · S/N 28-7990418 N2238HRhodes Mike A · Independence, ORBuilt 1953 · S/N 25644 N2238UHewitt Robert E · Bybee, TNBuilt 1968 · S/N 479 N2238YFerrara Edmond · La Puente, CABuilt 1967 · S/N 17700038 N22395Morrison Donald D · Santa Clarita, CABuilt 1974 · S/N 17264063 N2239LGoss Andrew M · Clio, MIBuilt 1976 · S/N MB-821 N2239PCumbee Danny A · Geneva, ALS/N 23-848 N2239TErwin Chris L · Carson City, NVS/N 28-7125629 N223BECampbell Edward A · Anchorage, AKBuilt 1977 · S/N 17268915 N223DBGood Winds Aero LLC · Roseburg, ORBuilt 2000 · S/N 010197 N223HWChesnut Tara M · Wasilla, AKBuilt 1960 · S/N 12 N223JPJohnson Vernon S · Salem, ORBuilt 1998 · S/N JP-4 N223KMccroskey Wesley D · Kingston, TNS/N 692 N223KCNovember Alpha LLC · Dover, DEBuilt 2003 · S/N 3435 N223MGBuffalo Sales & Leasing LLC · Missoula, MTBuilt 2000 · S/N 3125 N223PSTonkin Randy C · Vashon, WABuilt 1991 · S/N 20223 N223TRTurner Lee W · Valdosta, GABuilt 1968 · S/N 17257757 N223UKWilliams Pat P · Salem, ORBuilt 1992 · S/N 2212 N223WDGilliam Preston T · Philadelphia, PABuilt 1964 · S/N 28-20366 N223WMMoore Warren C · Magnolia, TXBuilt 2005 · S/N 4193 N2240EKellogg Jeffrey D · Adams Center, NYBuilt 1978 · S/N 17271200 N2240GThunderbird Aircraft Company · Bloomington, MNBuilt 1978 · S/N 28-7916217 N2240KBurnet David A · Quinton, ALBuilt 1978 · S/N 28-7916233 N2240PAnderson Timothy H · Janesville, WIBuilt 1956 · S/N 23-849 N2240TJudie Bear Air LLC · Bend, ORFirst renewal noticeBuilt 1971 · S/N 28-7125625

Back to AD 80-04-03 R2