Skip to content

Registered aircraft · 5,075

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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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.

N601GZDependable Drain Cleaning And Plumbing Repairs LLC · Lake Charles, LABuilt 1976 · S/N 61P-0371-119 N601MAlvis Michael Ernie DBA · Sparta, TNBuilt 1975 · S/N 61P-0253-046 N601PSchmidt Richard E · Fort Myers, FLBuilt 1979 · S/N 61P06587963306 N601RBBandy Robert W · Ridgecrest, CABuilt 1969 · S/N 61-0040-77 N601SHJohnson Martin L · Henderson, NVBuilt 1970 · S/N 61-0067-124 N601TVOrlando Aircraft Sales LLC · Orlando, FLBuilt 2000 · S/N 0836 N601XSmc Developers Inc · San Jose, CABuilt 1977 · S/N 61-0393-117 N6020KDuont LLC · Portola Valley, CABuilt 2004 · S/N T18208236 N6024NRegistered aircraftS/N 14605 N6024PJohn D Holderman · Sarasota, FLBuilt 1993 · S/N 14608 N602DDSilver Creek Aviation Services · Fort Worth, TXBuilt 2012 · S/N T20609057 N602SCSale Reported · Marble Falls, TXSale reportedBuilt 2002 · S/N 3257286 N6030YReddick Brent · Paragould, ARBuilt 1969 · S/N 27-4370 N6034YTan American Corporation · New York, NYRegistration revokedBuilt 1966 · S/N 27-3219 N6038ZFlying C LLC · Oro Valley, AZBuilt 2001 · S/N 20038 N6039YAllen Aviation Inc · Aynor, SCBuilt 1966 · S/N 27-3224 N6044YPinnock Charles W · Port St Lucie, FLBuilt 1966 · S/N 27-3230 N6046YWells Douglas A · Chino, CAS/N 27-3233 N6050Union Valley Petroleum Corp · Enid, OKBuilt 2000 · S/N 3257125 N6052YCentral Kentucky Aviation Inc · Bardstown, KYBuilt 1966 · S/N 27-3243 N6058YEltgroth Peter G · Livermore, CABuilt 1966 · S/N 27-3251 N6062YJahba LLC · Coral Springs, FLBuilt 1966 · S/N 27-3257 N606CACv Wings LLC · Canby, MNBuilt 1972 · S/N 27-4853 N6071ZJones Wayne A · Miami, FLBuilt 2001 · S/N 20041 N607DMAdx LLC · Saint Marys, KSBuilt 2002 · S/N T18208138 N607JWMid-South Bulk Services Inc · West Memphis, ARBuilt 1976 · S/N 32R-7680137 N607KWWalsh Kevin T · Morristown, NJBuilt 1976 · S/N 32R-7680390 N6085YPharmair LLC · Jackson, MSBuilt 1966 · S/N 27-3287 N6089YAerosavant LLC · Towanda, PABuilt 1966 · S/N 27-3295 N6092YClean Waste Solutions LLC · Indianapolis, INBuilt 1966 · S/N 27-3298 N6095XAlvarez Frank A · Summerville, SCBuilt 1995 · S/N 20006 N60AY2701 Ne 27 Court LLC · Hollywood, FLBuilt 1981 · S/N 31-8152051 N60CGSaj Aviation LLC · Reading, PABuilt 1980 · S/N 318052206 N60GWBangert Computer Systems Inc · Shawnee, KSBuilt 1969 · S/N 60-0030 N60JJGauss Karl F · Tully, NYBuilt 1976 · S/N 14175 N60KSMay Phillip Edward · Florence, ALBuilt 1978 · S/N 60-0560-182 N60MBCurry Arnold J · Houston, TXBuilt 1966 · S/N 27-3544 N60TAAero Elite LLC · Springfield, MOS/N 31-7552094 N60TTOurhappyfamilyplane LLC · Mason, OHBuilt 1979 · S/N 32-7940151 N60VBVvs Implements LLC · Wilmington, DES/N 60-0182-080 N6106XAir Margarita Inc · San Juan, PRBuilt 1960 · S/N 500B-941-28 N610BWCentral Airlines Inc · Leawood, KSBuilt 1965 · S/N 1523-185 N610DBPvr Construction LLC · Wilmington, DEBuilt 2006 · S/N T18208504 N610LBWinters Jesse · New Braunfels, TXBuilt 1976 · S/N 32R-7680304 N610MAThomas Michael J · Malabar, FLBuilt 1966 · S/N 32-40105 N6114XHardy Gareth R · Thatcher, AZBuilt 1960 · S/N 500B-924-9 N6119VN6119v LLC · Boca Raton, FLBuilt 1995 · S/N 14629 N611ADValiair Lc Trustee · Casper, WYBuilt 2003 · S/N T18208196 N611DGMiller Stephen James · Shreveport, LABuilt 1993 · S/N 27-0156 N611DPInversiones Flg Inc · Dorado, PRBuilt 1977 · S/N 31-7812040

Back to AD 84-19-03 R1