Registered aircraft · 5,079

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.

N1002GFlying Fox Aviation LLC · Idaho Falls, IDBuilt 2000 · S/N 27-0295 N1005XSigler Lanny · Albuquerque, NMBuilt 2000 · S/N 27-0302 N1007VSmith Loren Dallas · Great Falls, MTS/N 73-31060 N100BJAllen David L · Eastpoint, FLBuilt 1966 · S/N 32-40077 N100BSC & C Logging LLC · Kelso, WABuilt 1966 · S/N 27-3431 N100CNAileron Aviation Inc · Sparta, TNS/N 27-7754050 N100ELLeading Edge Leasing LLC · Wilmington, DES/N 310Q-0688 N100EMKentem100 LLC · Asheboro, NCBuilt 1981 · S/N 31-8152196 N100GSPegasus Florida I Inc · San Diego, CABuilt 1974 · S/N P-301 N100JRLumland Properties LLC · Winchester, VABuilt 1969 · S/N 31-599 N100NESanborn Map Co Inc · Colorado Springs, COS/N 31-7712022 N100POut Island Magic LLC · Gainesville, FLBuilt 1982 · S/N 31-8252019 N100RTRanch 100 LLC · Fort Pierce, FLS/N 31-808 N100VFMeridian Aviation N100vf LLC · Mobile, ALBuilt 1977 · S/N 32R-7780539 N100WDEveryday Medicine LLC · Nicholasville, KYBuilt 1982 · S/N 32-8224008 N100XRTomsis Corp · Panama City, FLBuilt 1981 · S/N 31-8152169 N1016XRadial Holdings LLC · Fort Worth, TXBuilt 2000 · S/N 27-0292 N101AXFogg Britt · Springdale, ARS/N P427 N101BHMpdkm Inc · Las Vegas, NVBuilt 2003 · S/N 01 N101CEDurocher Alain P · Long Beach, CABuilt 1982 · S/N 32R-8229066 N101LCReading Randall C · Redlands, CABuilt 1972 · S/N 31037 N101LPGranite Boarding LLC · Loomis, CABuilt 2004 · S/N T18208265 N101MAPablo Air Charters LLC · New Freedom, PABuilt 1977 · S/N 31-7752186 N101PLHay William G Jr · Gualala, CAS/N 27-7754156 N101TKLensing Wayne K · Popular Grove, ILBuilt 1980 · S/N 32R-8029062 N101WCRamey Curtis · Hilton Head Island, SCBuilt 1976 · S/N 32R-7680381 N101YBCowan Lance E · Watonga, OKBuilt 1969 · S/N 31-406 N1021PYurok Tribe Construction Corp · Klamath, CABuilt 2005 · S/N T18208383 N10262Davoli Third Family Limited Partnership · Lighthouse Point, FLBuilt 2006 · S/N T18208495 N1026CMooney Howard James Jr · Lake Wales, FLBuilt 1995 · S/N 27-0203 N1027FFilarski Darryl M · Grosse Ile, MIBuilt 1971 · S/N 32-7140036 N1028GCreed Brian H · Fredericksburg, VABuilt 2005 · S/N T18208381 N1029TThomson Heath · Portola Valley, CABuilt 1999 · S/N T20608067 N1029XBaden Frederick Richard · Mc Arthur, OHBuilt 1975 · S/N 32-7540181 N102EASteves Atv Services Inc · Oceano, CABuilt 1976 · S/N 32R-7680158 N102TMJunior Fernando Sporleder · Sarasota, FLBuilt 1976 · S/N 31-7712015 N102WHStuddiford James A · Lithia, FLS/N 31-7952066 N102WMStar Air Service LLC · Jacksonville, FLBuilt 1981 · S/N 31-8152112 N1031XJj Byrne International Inc · Steamboat Springs, COS/N T18208268 N1033TManzo Deborah S · Lake Placid, FLBuilt 1973 · S/N 27-7405302 N1036LN1036l Corp · Wilmington, DEBuilt 1976 · S/N 27-7654135 N1036XMotley Douglas Trustee · Rehoboth Beach, DEBuilt 1975 · S/N 32-7540131 N103ATWjm Aviation LLC · Bridgeville, PABuilt 1970 · S/N 32-40951 N103BUColorado Aircraft Corp · Watkins, COS/N 31-7405202 N103EAJwp Group LLC · Long Island, MEBuilt 1976 · S/N 32R7780054 N103ENKjs Development LLC · Temecula, CABuilt 1995 · S/N 4622186 N103GLNaylor Aviation LLC · Columbia, MOBuilt 1978 · S/N 31-7912023 N103HPMcfarland Natalie · Roseburg, ORBuilt 1965 · S/N 24-4153 N103MRDeepvine Partners LLC · Simonton, TXBuilt 2004 · S/N T20608455 N1041CHelzer Timothy · Tucson, AZBuilt 2003 · S/N 270321

Back to AD 84-19-03 R1