Skip to content

Registered aircraft · 26,232

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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.

N66397Petersen Bradley L · Bellingham, WABuilt 1974 · S/N 15076021 N6639APeach Christopher G · Waterville, MNBuilt 1956 · S/N 28739 N6639SMoen Richard C · West Dundee, ILS/N 15067439 N663FClark Russell J · Woodburn, INS/N 6-6827 N66402King Dwayne W · Sutton, AKBuilt 1974 · S/N 15076025 N6640ABunger Glenn H · Kirkland, ILBuilt 1956 · S/N 28740 N6640ELarkin Marion J · Salome, AZBuilt 1959 · S/N 56140 N6640FFlying High LLC · Gore, VABuilt 1966 · S/N 15063240 N6640GKruckeberg Leroy A · Sanford, NCS/N 15072140 N66412Farris Chad M · Bronte, TXBuilt 1975 · S/N 15076032 N6641FKatzenberger Devin T · Little Falls, MNBuilt 1966 · S/N 15063241 N6641GWalborn Carl L · Sun City, AZBuilt 1970 · S/N 15072141 N66420Ware Charles W Jr · Atmore, ALBuilt 1974 · S/N 15076035 N66422Zaleski-Johnson Laura · Mays Landing, NJBuilt 1974 · S/N 15076036 N66425Biornstad John A · Big Lake, AKBuilt 1974 · S/N 15076039 N6642ATundra Aviation Inc · Casselton, NDS/N 28742 N6642FSomerset Flying Club · Basking Ridge, NJBuilt 1966 · S/N 15063242 N6642GBurgmeier Peter W · North Vernon, INBuilt 1970 · S/N 15072142 N6642SSellers Douglas D · Webster, NYBuilt 1967 · S/N 15067442 N66437Fluno John I · San Anselmo, CAS/N 15076049 N66439Mancini James N · Baltimore, MDBuilt 1974 · S/N 15076051 N6643AMoore Michael J · Monroe, UTBuilt 1956 · S/N 28743 N6643FAyresouth Aviation Inc · Lithia Springs, GABuilt 1966 · S/N 15063243 N6643GStokes Patricia A · Nenana, AKFirst renewal noticeBuilt 1970 · S/N 15072143 N66440Tenenboym Dennis Alexander · Pinellas Park, FLBuilt 1974 · S/N 15076052 N6644GLive2flyfl Inc · Wilmington, DEBuilt 1970 · S/N 15072144 N6644NKratz Bradley L · Indiana, PABuilt 1952 · S/N 5-13044 N6644TGreenfield Amanda J · Palo, IABuilt 1960 · S/N 15059044 N66452Bedard Michael J Trustee · Madison, ALBuilt 1974 · S/N 15076059 N66453Beaudry Phillip H · Newport, VTBuilt 1974 · S/N 15076060 N66455Soendergaard Carsten · Aguila, AZBuilt 1974 · S/N 15076061 N66459Amelia Reid Aviation LLC · San Jose, CABuilt 1974 · S/N 15076063 N6645NTripp Charles L · Weirsdale, FLBuilt 1952 · S/N 5-13045 N6645TMcelroy James S Jr · Goddard, KSBuilt 1960 · S/N 15059045 N66463Sikkema Romke P · Sebring, FLBuilt 1974 · S/N 15076065 N66467Joe Dory Aviation LLC · Star, IDS/N 15076068 N66469Pirtle Sandra Rinehart · Winnsboro, TXBuilt 1974 · S/N 15076070 N6646ERegistration Pending · Elbert, CORegistration pendingBuilt 1959 · S/N 56146 N6646GJenkinson Jeffery J · Montgomery, TXS/N 15072146 N6646NBarnhart Tyler A · Vero Beach, FLS/N 4-13046 N6646TGillespie Justin M · Greensboro, NCS/N 15059046 N66472Bgmaviate LLC · Fairfax, VABuilt 1974 · S/N 15076072 N66478Mason John M · Gilbert, AZBuilt 1974 · S/N 15076074 N6647HBartholomew James F · Storm Lake, IABuilt 1946 · S/N 19848 N6647NHooten James T · Redding, CABuilt 1952 · S/N 5-13047 N6648EEverest Builders LLC · Cheyenne, WYS/N 56148 N66494Graham Luke R · Rushville, NEBuilt 1974 · S/N 15076081 N6649AShaw Frank Edward · Chestertown, NYBuilt 1956 · S/N 28749 N66501Sanders Robert M · Youngsville, NCBuilt 1974 · S/N 15076084 N66502Dewey Holdings LLC · Florence, ALBuilt 1974 · S/N 15076085

Back to AD 94-05-05 R1