Skip to content

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.

N316MABlue Side Up Inc · Islamorada, FLBuilt 1976 · S/N 32-7640112 N3176HG B T S LLC · Yatesville, GAS/N 31-7300913 N31795Kshr Av8rs LLC · Sheridan, WYBuilt 1978 · S/N 32R-7887010 N317GCGospel Carrier International Inc · North Potomac, MDBuilt 2000 · S/N 4636292 N317HABauer Aviation LLC · Saint Germain, WIBuilt 1977 · S/N 31-7812043 N317PZFairmont State University · Fairmont, WVBuilt 1980 · S/N 27-8054047 N31847Nevada Air Partners LLC · Boulder City, NVS/N 32R-7887011 N318CWHeronimus Kevin A · Lebanon, TNBuilt 1998 · S/N 4636153 N318PKValiair Lc Trustee · Casper, WYBuilt 1978 · S/N 32R-7887037 N318RHN72jp Inc · Annandale, VABuilt 1976 · S/N 27-7654184 N318SPace Glen M · Columbia, MSS/N 76-32-164 N31920Sarasin Stuart P · Au Train, MIS/N 32R-7887015 N31932Air Cargo Solutions Inc · Two Rivers, AKBuilt 1973 · S/N 31-7405144 N31961Duncanson Scott Alexander · Grand Blanc, MIBuilt 1978 · S/N 32R-7887017 N31981Elusive Aviation Inc · Pflugerville, TXBuilt 1978 · S/N 32R-7887018 N31998Lance Group LLC · Moab, UTBuilt 1978 · S/N 32R-7887019 N319RDN319rd LLC · Casa Grande, AZBuilt 1998 · S/N 4636139 N31FBBreazeale Annette M · N Richlnd Hls, TXBuilt 2005 · S/N 3350 N31PRAlpha Whiskey 1 LLC · Brandon, MSBuilt 1979 · S/N 317952049 N31PWClark David L · Washoe Valley, NVBuilt 1968 · S/N 32-40510 N31RDIsland Bound LLC · Dunedin, FLS/N 31-7852059 N31TEMiller David A · Albany, ORBuilt 1984 · S/N 31-8452012 N31WHDerbecker David G · Katy, TXBuilt 1969 · S/N 24-4810 N32037Conyers Jeffrey P · Sevierville, TNBuilt 1974 · S/N 32-7540009 N32117Stough Stephen A · Reno, NVBuilt 1974 · S/N 32-7540016 N3212ESmith Paul N · Dedham, MEBuilt 1993 · S/N 27-0162 N32139Bidzy Ta Hot Aana Corporation · Dillingham, AKFirst renewal noticeBuilt 1974 · S/N 32-7540017 N3214WHolcombe Vell C · Hershey, PABuilt 1965 · S/N 32-15 N32187Free Lutheran Association Of Pilot Supporters Inc · Plymouth, MNBuilt 1974 · S/N 32-7540021 N32197Brunzlick Larry R · Chuckey, TNBuilt 1974 · S/N 32-7540022 N321ACB & H Aviation LLC · Marion, KYBuilt 1974 · S/N 27-7405334 N321AMGuerin Michael L · Torrington, WYBuilt 1975 · S/N 75-31117 N321ASAirtravel LLC · Reno, NVBuilt 1976 · S/N 61P-0358-111 N321HPNfas LLC · League City, TXBuilt 1974 · S/N 32-7440099 N321KAMid Valley Air LLC · Jessup, PABuilt 2000 · S/N 3257142 N321MAKnox Props Aviation LLC · Cookeville, TNBuilt 2002 · S/N 3257311 N321NCArizona Air Salvage · Phoenix, AZBuilt 1977 · S/N 27-7754101 N321PWSquaw Valley Air Force LLC · Reno, NVS/N T18208171 N321SPWest Electrical Contractors Inc · Newberry, SCBuilt 1974 · S/N 32-7440119 N321TCRice Justin M · Minot, NDBuilt 1990 · S/N 27-0038 N3227QBrands Robert C · Cary, NCS/N 32R-7780299 N3228QR&G Aviation LLC · Jonesboro, ARS/N 32R-7780300 N322MEMast Enterprises Equipment LLC · South Boston, VABuilt 1989 · S/N 4622064 N322MMRiver Transport LLC · Redlands, CABuilt 2002 · S/N T18208126 N322TMSkywagons.Com LLC · Placerville, CABuilt 1991 · S/N 27-0084 N322WNo Business LLC · Kalispell, MTBuilt 1978 · S/N 32R-7887190 N32303Eagle Air Solutions LLC · Johnson City, TNBuilt 1974 · S/N 32-7540029 N3231BEast Martin D · Nicholasville, KYBuilt 1974 · S/N 32-7540030 N32348Ramsey Time LLC · Winter Garden, FLBuilt 1974 · S/N 32-7540032 N3234LTarrant County College · Fort Worth, TXBuilt 1967 · S/N 27-3626

Back to AD 84-19-03 R1