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.

N59764Warbelows Air Ventures Inc · Fairbanks, AKBuilt 1975 · S/N 31-7652037 N5977YRed State LLC · Daytona Beach, FLBuilt 1966 · S/N 27-3148 N59809Lou Dell Aviation LLC · Simpsonville, SCBuilt 1976 · S/N 31-7612037 N59826Air Arctic Inc · Fairbanks, AKBuilt 1976 · S/N 31-7652077 N59829Warbelows Air Ventures Inc · Fairbanks, AKBuilt 1976 · S/N 31-7652081 N5982YDawkins Karlene A · Coral Springs, FLBuilt 1966 · S/N 27-3155 N59848Sanborn Map Co Inc · Colorado Springs, COBuilt 1976 · S/N 31-7612052 N59865Mccorkle Joseph P II · Tyronza, ARBuilt 1976 · S/N 31-7612065 N59867Cooper Keith L · Tabernash, COBuilt 1976 · S/N 31-7612068 N5986YBlackhawk Holding Corp · Wilmington, DEBuilt 1966 · S/N 27-3159 N59870Talkeetna Aero Services Inc · Anchorage, AKS/N 31-7612071 N598MAMartini Richard · North Haven, CTBuilt 1997 · S/N 3257009 N59906Alpha Whiskey 2 LLC · Brandon, MSBuilt 1974 · S/N 31-7552027 N5991VDebry Michael W Trustee · Palmdale, CABuilt 1977 · S/N 32R-7780386 N59936Kelly Kent R · Montgomery, ALBuilt 1975 · S/N 31-7512019 N59982Duck L'Ranch LLC DBA · Fort Lauderdale, FLBuilt 1975 · S/N 31-7552071 N59984Alpha Whiskey 1 LLC · Brandon, MSBuilt 1975 · S/N 31-7512042 N59987Wings As Eagles Mission Air Serv Inc · Oshkosh, WIBuilt 1975 · S/N 31-7552081 N599AHAvtran LLC · Clayton, MOBuilt 1984 · S/N 31-8452019 N59BBCooper Richard B · Fort Worth, TXBuilt 1981 · S/N 32-8124034 N59CARegistered aircraftBuilt 1994 · S/N 129 N59FCLamb Farms Inc · Oakfield, NYBuilt 1979 · S/N 31-7952117 N59GYChieftain N59gy LLC · Saint Augustine, FLBuilt 1977 · S/N 31-7852017 N59JCPegasus Air Charter LLC · Hartford, CTBuilt 1979 · S/N 31-7952181 N59TXThacker Jackie W · Hineston, LABuilt 1978 · S/N 32R-7887105 N5CQDlc Aviation LLC · Lakeland, GABuilt 1973 · S/N 31-7400977 N5HMEvans Hayward D · Saint Augustine, FLBuilt 1973 · S/N 27-7305041 N5LLInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 31-7812041 N5MHGould Ralph Harvey Jr · White Cloud, MIBuilt 1967 · S/N 32-40268 N5SWPrendergast Gene D · Willcox, AZBuilt 1978 · S/N 32R-7887150 N5YGSethjay LLC · Washington, DCBuilt 1995 · S/N 4636001 N60030Jmj Properties LLC · Atchison, KSBuilt 2006 · S/N T18208500 N6007VHauser Scott · Towanda, PABuilt 1971 · S/N 31024 N600AGBisignano Michael · Palm Coast, FLBuilt 1989 · S/N 4622053 N600AHCoastal Road Aviation LLC · Mukilteo, WABuilt 1969 · S/N 24-4863 N600AZDykema Carl F · Davie, FLBuilt 1969 · S/N 61-0022 N600CRSilver Throne Aviation LLC · Anchorage, AKBuilt 1989 · S/N 4622060 N600EDWeskalnies Michael · Jarrettsville, MDBuilt 1969 · S/N 60-0013 N600FABeaver Creek Adventures LLC · Bangor, MEBuilt 1975 · S/N 60-0246-101 N600JGWiltcher Christopher Alex · Gallatin, TNBuilt 1969 · S/N 32-40726 N600JKMcdonald Harry · Toccoa, GABuilt 1975 · S/N 60-0257-104 N600NJKralta Enterprises LLC · Sioux Falls, SDBuilt 1975 · S/N 60-0199-088 N600RSavanna Lakes LLC · Dover, DEBuilt 1969 · S/N 60-0018 N600RJRankin Richard · Germantown, TNBuilt 1979 · S/N 27-7954114 N600TEHutter Charles G · Carson City, NVBuilt 1973 · S/N 61-0146-077 N6011YTab Associates Inc DBA · Port Saint Lucie, FLBuilt 1966 · S/N 27-3193 N6017YTulsa Technology Center School District No 18 · Tulsa, OKS/N 27-3200 N601ALValley Group Inc · Fishersville, VABuilt 1969 · S/N 61-0036-73 N601BBKing Aviation Services LLC · Marietta, OHBuilt 1977 · S/N 61P-0431-159 N601EMValestin Donald P · Queen Creek, AZBuilt 1977 · S/N 61P-0389-131

Back to AD 84-19-03 R1