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.

N1920JDerrick James E · Godley, TXBuilt 1976 · S/N 14020 N19277Roundtree Sod Service Inc · Jacksonville, FLBuilt 2005 · S/N T18208437 N1937JBryant Joe Henry Jr · Meridian, MSBuilt 1976 · S/N 14037 N1938JCsi Asset Management Inc · Naples, FLBuilt 1976 · S/N 14036 N1938SCavu Aviation LLC · North Yarmouth, MEBuilt 1973 · S/N 3167 N193TM193 Tango Mike LLC · Winter Haven, FLS/N 84 N194PMDye David A · Point Clear, ALBuilt 1993 · S/N 4622146 N194ZUsda Forest Service Fepp · Malvern, ARBuilt 1965 · S/N 1510-182 N19500Wright Bros Flying Club LLC · Lewes, DEBuilt 1994 · S/N 4622163 N1953HBritton Scott M · Fairview, TXBuilt 1977 · S/N 32-7740044 N195JGN195jg Aviation LLC · Port Republic, NJBuilt 1994 · S/N 4622173 N1963JTeam Robinson Holdings LLC · Denver, NCS/N 328024038 N1968TGilbert Zachary A · Jekyll Island, GABuilt 1968 · S/N 32-40376 N1969HTrn Aviation LLC · Mcallen, TXS/N 3257066 N196DBBe Right Back Aviation LLC · Boca Raton, FLBuilt 1973 · S/N 27-7405273 N1970PWootton Donald W · Houston, TXBuilt 1981 · S/N 32R-8129044 N1977JPicornell Francisco J · Malabar, FLBuilt 1976 · S/N 14080 N197LABg Family Limited Partnership · Edinburg, TXBuilt 1997 · S/N 4636098 N197MAShore Air LLC · Trappe, MDBuilt 1997 · S/N 4636079 N197PMRegistered aircraftBuilt 1997 · S/N 4636086 N1982HWasley David L · Harwinton, CTBuilt 1977 · S/N 32R-7780212 N1982KN1982k LLC · Wilmington, DEBuilt 2005 · S/N T18208442 N1983HGroeteke Robert W · Ravenna, NEBuilt 1977 · S/N 32R-7780213 N1986VSpeer 182 LLC · Kalispell, MTBuilt 2005 · S/N T18208443 N198GME B Marine LLC · Lantana, FLBuilt 1974 · S/N 32-7440126 N198JCLong Bayou LLC · Vero Beach, FLBuilt 1998 · S/N 3257028 N198TCSky Ryder Aviation LLC · Lewisville, TXBuilt 1998 · S/N 3257047 N198WCy Properties Inc · Durango, COBuilt 1997 · S/N 3257012 N1994BGxi Holdings LLC · Fort Worth, TXBuilt 1994 · S/N 27-0186 N199DSIsland Wings Inc · Fort Lauderdale, FLBuilt 1973 · S/N 31-7400980 N199TCStearns Nathaniel · Rochester, NYBuilt 1999 · S/N 3257088 N19DKRichardson Cotton Inc · Wilmington, DEBuilt 2015 · S/N 18282374 N19JPSheldon Law Pllc · Scottsdale, AZBuilt 1997 · S/N 4636119 N19KCGrays Bay LLC · Warrenton, ORBuilt 1970 · S/N 274516 N19RDDennison Ronald Walton Trustee · San Jose, CABuilt 1966 · S/N 24-4597 N19SCSacred Heart Medical Group Inc · Riverside, CABuilt 2001 · S/N T18208101 N1ATAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1974 · S/N 31-7405478 N1GLSmith Alfred N D IV · Lake Wylie, SCBuilt 1967 · S/N 27-3826 N1JQJacquot Daniel C · Colorado Springs, COBuilt 1965 · S/N 24-4327 N1NXBirchwood Farms Inc · Hope Mills, NCBuilt 1962 · S/N TD-536 N1SYPacific Fleet Aviation LLC · Rochester, NYS/N 27-7654186 N1THall George E Jr · Hillsborough, NCBuilt 1969 · S/N 60-0014 N1UGRegistered aircraftS/N 32R-7780308 N1WYBultron Cristina · Ocala, FLBuilt 1964 · S/N 24-4018 N200CEBrewer Erich J · Thompson, MOBuilt 1977 · S/N 14257 N200CTAlpha Bravo 1 LLC · Willow Street, PABuilt 1989 · S/N 27-0016 N200CXPotter Aviation LLC · Milford, NJBuilt 1984 · S/N 31P-8414042 N200HMBill Keck Aviation LLC · Marlow, OKBuilt 1975 · S/N 32R-7680025 N200MAlliance Aircraft Group LLC · Denver, COS/N H-11 N200P10x Aviation Partners LLC · Stuart, FLBuilt 1980 · S/N 31-8052124

Back to AD 84-19-03 R1