Skip to content

Registered aircraft · 20,481

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-10-01-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-10-01-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-10-01-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-10-01-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-10-01-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-10-01-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.

N736YLFive Star Electric Inc · Lakin, KSBuilt 1978 · S/N R18200789 N736YYYankee Yankee LLC · Bend, ORBuilt 1978 · S/N R18200795 N736YZHamilton Rial Pc · Austin, TXBuilt 1978 · S/N R18200796 N736ZGWhiskey Romeo 1 LLC · Jacksonville, FLS/N R18200800 N736ZPPaul Roussell LLC · Delhi, IABuilt 1978 · S/N R18200806 N736ZVBerry Andrew J · Saint Paul, MNBuilt 1979 · S/N R18200812 N736ZXRedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1978 · S/N R18200813 N7370SNewman Carlon Keith · Cypress, TXBuilt 1976 · S/N 18265161 N7371Registered aircraftBuilt 1998 · S/N 18280212 N7371NBradley Larry · Olustee, OKFirst renewal noticeBuilt 1974 · S/N 18263154 N7371QHarbor Aviation LLC · Harbor Springs, MIBuilt 1972 · S/N 18261011 N7371SJacobson Justin D · Fallon, NVBuilt 1976 · S/N 18265162 N73727Redtail Partners LLC · Moab, UTBuilt 1980 · S/N 20700617 N73733Muffett Pat D · Eastsound, WABuilt 1980 · S/N 20700618 N7373EQuist Donald G · Ridgecrest, CABuilt 1960 · S/N 57073 N7373NPyne Jeffrey S · Spanish Fork, UTBuilt 1974 · S/N 18263156 N7373QMidgette Damon · Santa Clarita, CAS/N 18261013 N7373SSkiles Jere K · Narvon, PABuilt 1976 · S/N 18265164 N7373UYr-Aircraft Leasing LLC · Bethel, AKBuilt 1977 · S/N 20700423 N73742Adams Bruce M · Santa Fe, NMBuilt 1980 · S/N 20700619 N7374QBrooks Lee · Miami, FLBuilt 1972 · S/N 18261014 N7375NEllison Air Inc · Anchorage, AKS/N U20603641 N7375QFort Sam Houston Flying Club · San Antonio, TXBuilt 1972 · S/N 18261015 N7375SSutherland Joan Ellen · Richmond, VABuilt 1976 · S/N 18265166 N7376HMph Aviation LLC · Toccoa, GABuilt 1981 · S/N 18267912 N7376NSale Reported · Bloomburg, TXSale reportedBuilt 1974 · S/N 18263159 N7376QThompson Christopher John · Odessa, FLBuilt 1972 · S/N 18261016 N7377QKnights Aviation LLC · Cuyahoga Falls, OHBuilt 1972 · S/N 18261017 N73789Ryan Air Inc · Anchorage, AKBuilt 1980 · S/N 20700629 N7378NWhitmarsh Stephen C · Marysville, CABuilt 1974 · S/N 18263161 N7379QVolair Lineas Aereas Del Caribe Sa LLC · Tamarac, FLBuilt 1972 · S/N 18261019 N7379S818 Flyers LLC · La Crescenta, CABuilt 1976 · S/N 18265170 N7379UIliamna Air Taxi Inc · Iliamna, AKBuilt 1978 · S/N 20700427 N737FUWarren Darryl · Clinton, ARBuilt 1978 · S/N R18200823 N737FYMiller Davette D · Mesa, AZBuilt 1979 · S/N R18200826 N737GDEfc Aviation LLC · Lancaster, KYBuilt 1979 · S/N R18200827 N737HNAvey Gregory B · Saint John, INBuilt 1979 · S/N R18200829 N737HPLinn Anthony B · Westborough, MABuilt 1979 · S/N R18200830 N737JSBoren Aviation LLC · Knoxville, TNBuilt 1978 · S/N R18200839 N737LQAmbrosio Michael · Cypress, TXS/N R18200847 N737LTMcgehee Robert · Baton Rouge, LABuilt 1979 · S/N R18200849 N737MDThorn Williard F · Canton, MABuilt 1973 · S/N 18261672 N737NDCochise College · Douglas, AZBuilt 1978 · S/N R18200859 N737PFN737jj Aviation Inc · Punxsutawney, PABuilt 1979 · S/N R18200864 N737TSSeven Tango Sierra LLC · Yuma, AZBuilt 1979 · S/N R18200882 N737VUBlog Thomas M · Santa Fe, NMBuilt 1979 · S/N R18200887 N737XXEgan Walter G Jr · Port Orange, FLBuilt 1979 · S/N R18200894 N737YKKaher Ryan G · Menlo Park, CABuilt 1979 · S/N R18200895 N737ZZRandick George A · Birch Run, MIBuilt 1979 · S/N R18200901 N7380NWolverton Engineering Inc · Collins, MSBuilt 1974 · S/N 18263163

Back to AD 84-10-01 R1