Skip to content

Registered aircraft · 81,720

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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.

N2231MGreat Lakes Aviation Services Inc · Kimball, MIS/N 32-975 N2232Reigle Aviation · Palmyra, PABuilt 1971 · S/N 1-GP 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 N2232QStender Michael L · Davenport, IABuilt 1979 · S/N 28-7911106 N2232WJkj Aviation · Wilmington, NCBuilt 1979 · S/N 28-7916334 N2233Jacobson Luke W · Reno, NVBuilt 1968 · S/N 62 N22336Goldshlager Benjamin · Boca Raton, FLBuilt 1978 · S/N 28-7911004 N2233BRollin Virginie C · Mountain House, CABuilt 1978 · S/N 28-7816598 N2233CFreeland Robert D · Victor, MTBuilt 1978 · S/N 28-7990147 N2233LBecker Leo Henry · Leavenworth, KSBuilt 1979 · S/N 32-7940028 N2233MPutnam John P · Weirsdale, FLS/N 18280069 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 N2235CAnderson Nick A · Cynthiana, KYBuilt 1978 · S/N 28-7911024 N2235ELivingston Eric L DBA · Winchester, INBuilt 1978 · S/N 17271198 N2235LCarter Dale · Riga, MIBuilt 1976 · S/N M-1905 N2235VE & R Aviation Services Inc · Long Beach, CABuilt 2007 · S/N 172S10478 N2235WSamuels Walter E · Wilmington, NCBuilt 1969 · S/N 30-1844 N2236CAlexander James E Jr · Fort Worth, TXBuilt 1978 · S/N 28-7911025 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 N22373Roche Timothy P · Falls Church, VABuilt 2007 · S/N 18281928 N2237KCarolina Air LLC · New London, NCBuilt 1978 · S/N 28-7916232 N2237LDeatherage Christina M · Goshen, OHBuilt 1976 · S/N M1885 N2237QJenkins John E Jr · Long Valley, NJBuilt 1979 · S/N 28-7911107 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 N2238LDeris Jeffrey J · Madison, MSBuilt 1976 · S/N MC-459 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 N2239AGoring Hugh W · Rimrock, AZBuilt 1952 · S/N 22-635 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 N223APJuliet Aviation LLC · Oregon City, ORBuilt 2025 · S/N 172S13440 N223BRegistered aircraftAssigned, pending cancellationS/N 001 N223BDN223bd LLC · Fresno, CABuilt 1980 · S/N R18201454 N223BECampbell Edward A · Anchorage, AKBuilt 1977 · S/N 17268915 N223BWBridgewater State University · Bridgewater, MABuilt 2000 · S/N 17280950

Back to AD 81-18-04 R2