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.

N44PTDaedalus Flight Service Inc · P FokaiaBuilt 1972 · S/N 27-4793 N44RLCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1973 · S/N 31-7401217 N45002New England Aviation Air Charters LLC · Plainville, CTBuilt 1980 · S/N 31-8052161 N4500FEngle David · Memphis, TNBuilt 1976 · S/N 32R-7680455 N45014Marc Inc · Bolton, MSBuilt 1980 · S/N 31-8052171 N4501B70 North LLC · Anchorage, AKBuilt 1980 · S/N 31-8052168 N4501LPleasant Aviation LLC · Mount Pleasant, TXBuilt 1968 · S/N 001 N45052Talkeetna Aero Services Inc · Anchorage, AKBuilt 1980 · S/N 31-8152063 N4505XBlack Hound Aviation LLC · Austin, TXBuilt 1975 · S/N 32R-7680022 N4507LAntique Preservation Associationof Greenfield · Greenfield, IABuilt 1973 · S/N 006 N450KCCharles City Aeronautics Inc · Charles City, IABuilt 1978 · S/N 31-7852092 N4513QBobcat Aviation LLC · Northfield, MNBuilt 1977 · S/N 32-7740066 N452PDBpd Enterprises LLC · Ponte Vedra Beach, FLBuilt 2004 · S/N T18208282 N4535SWintson James R · Cornelius, NCBuilt 1976 · S/N P-384 N4537FJohnson Justin · Ashland, ORBuilt 1976 · S/N 32R-7680458 N4552XWozniak Robert F · Baltimore, MDBuilt 1975 · S/N 32R-7680027 N4557XPrime Property Investments LLC · Pevely, MOBuilt 1975 · S/N 32R-7680028 N455MAA & J Aviation LLC · Madison, MSBuilt 2001 · S/N 32-57205 N455TWTd Air LLC · Cannon Beach, ORBuilt 2001 · S/N 4636323 N4563FOcean City Flying Club Inc · Newport, RIBuilt 1976 · S/N 32R-7680460 N4563XTriple D LLC · Scotland, PABuilt 1975 · S/N 32R-7680029 N456DALiberty Air LLC · Christiansted, VIBuilt 1979 · S/N 31-7912103 N456EASpasco LLC · Helena, MTBuilt 1989 · S/N 4622042 N456LWPhillips Operating Lp · Shreveport, LABuilt 1987 · S/N 63 N456PBooth Donald V · Denison, TXS/N 24-3276 N456TBValentine David L · Katy, TXBuilt 1999 · S/N 1911 N4584TLion Air LLC · South Heart, NDBuilt 1972 · S/N 32-7240087 N458MGFlywheel LLC · Charleston, WVBuilt 2005 · S/N T18208393 N4595XManoli Louis Charles · Wampum, PABuilt 1975 · S/N 32R-7680035 N4599XStar Marianas Air Inc · Saipan, MPBuilt 1975 · S/N 32-7640040 N45RNMeader Daniel D · Columbia, SCBuilt 1970 · S/N 61-0056-105 N45VZStarlifter Aviation LLC · Fairborn, OHBuilt 2005 · S/N 27-0350 N461MBVeil Casey J · Jamestown, NDBuilt 2002 · S/N 3257302 N462HPPrescott Healthcare LLC · Prescott, AZBuilt 2000 · S/N 4636285 N462LTSilber Justin A · Atlanta, GABuilt 1996 · S/N 4636056 N462TMPalisades Creek Aircraft Co LLC · Thayne, WYBuilt 1989 · S/N 4622029 N462TTAir Enterprises LLC · Dover, DEBuilt 1968 · S/N 27-4042 N463HPBas Part Sales LLC · Greeley, COBuilt 2002 · S/N 4636335 N463JPJj Hughes Logistics LLC · Canyon, TXBuilt 1999 · S/N 4636216 N464CAAirfrank Inc · Hackensack, NJBuilt 1998 · S/N 3257054 N464LBPlane Austin LLC · Sherwood, ORBuilt 1993 · S/N 4622139 N464PMHnd Properties LLC · Montrose, COBuilt 1999 · S/N T20608053 N464SPMeshik Ground Service LLC · Port Heiden, AKBuilt 1974 · S/N 32-7440159 N4691FBelk William E · Labelle, FLBuilt 1976 · S/N 32R-7680474 N469JLKnaack Roland · Cumming, GABuilt 1979 · S/N 32R-7987023 N46BLGayle Todd S · El Paso, TXBuilt 1992 · S/N 27-0132 N46JCAdventures Air Express LLC · Malabar, FLBuilt 1997 · S/N 4636125 N46KJK-A Mirage LLC · Winnetka, ILBuilt 1996 · S/N 4636037 N46MYBeach Air LLC · Boynton Beach, FLBuilt 1975 · S/N 31-7552039 N46PHarrison Donna J · Eau Claire, MIBuilt 1966 · S/N 24-4470

Back to AD 84-19-03 R1