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.

N5806YDan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1965 · S/N 27-2939 N580SPWatag Corp Trustee · Wilmington, DEBuilt 1965 · S/N 27-3046 N5818YWells John R · Gonzales, TXBuilt 1965 · S/N 27-2965 N581SGOetting William C · Midland, ORS/N 3257049 N5824YDonahue Sean M · Fort Lauderdale, FLBuilt 1965 · S/N 27-2972 N5825YTalmage John R · Kalispell, MTS/N 27-2945 N5832NWitherington III William A · Newnan, GABuilt 1978 · S/N 14381 N5832VPowless Robert A · Tierra Verde, FLBuilt 1993 · S/N 27-0144 N5847YC&C Aviation LLC · Amarillo, TXBuilt 1965 · S/N 27-2998 N5848VSheffield David A · Silsbee, TXBuilt 1977 · S/N 32R-7780368 N584LQAir Shares LLC · Casper, WYBuilt 2005 · S/N 18281600 N5854FBravo Sierra LLC · Middletown, DES/N 32R-7780021 N5867PWickenheiser Kevin John · Detroit, MIBuilt 1959 · S/N 24-950 N5868VSiefken Arnold G · Jamestown, NDBuilt 1977 · S/N 32R-7780369 N5870VHagerstown Regional Aero Club · Dallastown, PABuilt 1977 · S/N 32R-7780370 N5880KCjc LLC · Syracuse, UTBuilt 2005 · S/N T20608581 N5887YAlmost There Air LLC · Daytona Beach, FLBuilt 1965 · S/N 27-3040 N588BSMeives Mark J · Barneveld, WIBuilt 1978 · S/N 32R-7887140 N5896YPatentcentral LLC · Hollywood, FLBuilt 1965 · S/N 27-3051 N589RTPoling George T · Clayton, NMBuilt 2005 · S/N T20608572 N58BVVarney Aviation LLC · Bangor, MEBuilt 1999 · S/N T20608036 N58EBConservation Flight LLC · Bronx, NYBuilt 2003 · S/N T20608404 N58KMOjito Osvaldo A · Miami, FLBuilt 1974 · S/N 27-7405440 N58PGTeterboro School Of Aeronautics Inc · Virginia Beach, VABuilt 1967 · S/N 27-3772 N58RDDuncan Ronald A · Anchorage, AKS/N 115 N58RJLogan Flyers LLC · Logan, OHBuilt 1968 · S/N 27-3971 N5900NMackin Marvin L · Merced, CABuilt 1979 · S/N 14513 N5903NMotte Larry P · La Porte, TXBuilt 1979 · S/N 14520 N590DRRichardson Dean A · St Thomas, VIBuilt 1968 · S/N 1817-23 N5910TVriesenga Todd · Rockford, MIBuilt 2004 · S/N T20608457 N5910VMaffei Michael C · Winchester, MABuilt 1977 · S/N 32R-7780377 N5911YDileo Steven J · Gallatin, TNBuilt 1965 · S/N 27-3067 N5918DSkywalker Air LLC · Bellingham, WABuilt 2001 · S/N T18208039 N5920YAdvanced Mosquito Control & Technology Inc · Boyle, MSBuilt 1965 · S/N 27-3077 N5922VHopper David · Mcgregor, TXBuilt 1977 · S/N 32R-7780378 N5922YUltimate Air Parts LLC · Strasburg, VABuilt 1965 · S/N 27-3080 N5930YHopkins Frank Michael · Wilmington, DEBuilt 1965 · S/N 27-3091 N5938YFly For Fun Aircraft LLC · Rockville, MDBuilt 1965 · S/N 27-3103 N5942FBartak Paul R Jr · Saint Peters, MOBuilt 1976 · S/N 32R-7780022 N5948YFbm LLC · Laporte, INS/N 27-3114 N594CMCameron John B · Iredell, TXBuilt 2004 · S/N T18208332 N594QHager Cecilia J · Fredericksburg, TXBuilt 1999 · S/N T20608024 N595SMLapoint LLC · Holland, OHBuilt 1995 · S/N 4622185 N5961YWillis Burlin T · Wasilla, AKBuilt 1965 · S/N 27-3130 N5963YS And S Aviation Consulting · Hampshire, ILBuilt 1966 · S/N 27-3132 N59681Aircraft Montana LLC · Helena, MTBuilt 1977 · S/N 36-7760094 N5969VNiver Randall H · Potomac, ILBuilt 1977 · S/N 32R-7780384 N596LKcc Aero LLC · Guaynabo, PRBuilt 1977 · S/N 31-7712036 N5972YBm Aviation LLC · Vinton, VABuilt 1966 · S/N 27-3143 N59752Visionaire Enterprises LLC · Statesville, NCBuilt 1975 · S/N 31-7612010

Back to AD 84-19-03 R1