Skip to content

Registered aircraft · 25,370

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N30218Mckillip Kirby G · Kemah, TXBuilt 1968 · S/N 17701127 N3021EAircraft Solutions LLC · Spokane, WABuilt 1978 · S/N 17271405 N30225Hall Curtis B · Shepherdsville, KYBuilt 1968 · S/N 17701131 N30231Pankratz Paul J · Lakeville, MNBuilt 1968 · S/N 17701136 N30235Booher Harold D · Manchester, MOBuilt 1968 · S/N 17701139 N30238Nunley Dwight · Hawkins, TXBuilt 1968 · S/N 17701142 N30239Jones Gary E · Orange, CABuilt 1968 · S/N 17701143 N30250O'Connor Sean J · Newburyport, MABuilt 1968 · S/N 17701150 N30275Tomlinson Douglas F · Waunakee, WIBuilt 1968 · S/N 17701167 N30278Barron Joseph M · Des Moines, IABuilt 1975 · S/N 17264133 N30285Galena City School District · Galena, AKBuilt 1974 · S/N 17264135 N30293Advantage Aviation Services LLC · South Saint Paul, MNBuilt 1968 · S/N 17701177 N30297Siers Richard · Ocean Shores, WABuilt 1968 · S/N 17701178 N302AMHughes Jason · Visalia, CABuilt 1965 · S/N 618 N302DBHouston Chet H · Beaufort, SCBuilt 1968 · S/N 17701132 N302JAAviate LLC · Green Bay, WIBuilt 1977 · S/N 17269488 N30302Kamenar Service LLC · Mukwonago, WIBuilt 1968 · S/N 17701180 N30303Registration Pending · Meeker, CORegistration pendingBuilt 1968 · S/N 17701181 N30304Williams Rod · Atascadero, CABuilt 1968 · S/N 17701182 N30307Johnston Phillip Jr · Pensacola, FLBuilt 1968 · S/N 17701184 N30308Griffith Scot E · Glendale, AZBuilt 1968 · S/N 17701185 N3030EElon Aviation LLC · Burlington, NCBuilt 1978 · S/N 17271408 N30311Parker Yates · Wellington, TXBuilt 1968 · S/N 17701188 N30316L & M Aviation LLC · Creston, IAS/N 17701189 N30317Eagle Sky Patrol Inc · Deadwood, SDBuilt 1968 · S/N 17701190 N30328Martin Paul T · Tacoma, WABuilt 1968 · S/N 17701196 N30331Cardinal Lima LLC · Minneapolis, MNBuilt 1968 · S/N 17701197 N30346Cooke Bradley J · Belmont, NCBuilt 1968 · S/N 17701203 N30347Dennis Rick L · Poughkeepsie, NYBuilt 1968 · S/N 17701204 N30353Stracuzzi Charles J · Ocala, FLBuilt 1968 · S/N 17701207 N30357Cammack Brian W · Edgewood, NMBuilt 1968 · S/N 17701209 N30363Talbot Douglas J · Sandpoint, IDS/N 17701210 N30370Fellow Ship Aviation LLC · Monticello, GABuilt 1974 · S/N 17264136 N30387Watkins Bruce K · Houston, TXBuilt 1968 · S/N 17701226 N30390Rimmer Nathan S · Seattle, WABuilt 1968 · S/N 17701229 N30393Graden Timothy J · Polo, ILBuilt 1968 · S/N 17701231 N30396Sill John A · Cable, WIBuilt 1968 · S/N 17701233 N30399Schwanke Donald D · Springfield, ILBuilt 1968 · S/N 17701236 N303ACUlinski Daniel J · Glen Burnie, MDBuilt 1995 · S/N 755-95 N303LKWestwind Aviation Inc · Bremerton, WABuilt 1973 · S/N 17262140 N303SBBlom Wayne E Jr · Littleton, COBuilt 2001 · S/N 887-2001 N303SLBuffalo Aircraft Maintenance LLC · Ridgecrest, CABuilt 1994 · S/N 1201-94 N30404Cardinal Flyers LLC · Powell, OHBuilt 1969 · S/N 17701237 N30407Cardinal Cronies LLC · Clarinda, IABuilt 1968 · S/N 17701238 N30409Schmitt Cameron · Fort Dix, NJBuilt 1968 · S/N 17701239 N30413Eagle Sky Patrol Inc · Deadwood, SDS/N 17701240 N30418Young Matthew B · Brighton, ILBuilt 1969 · S/N 17701244 N30433Flying Hawks Inc · Palmyra, WIBuilt 1968 · S/N 17701251 N30436Carson Charles E · North Vernon, INBuilt 1968 · S/N 17701252 N30437Richards David N · Port Matilda, PABuilt 1968 · S/N 17701253

Back to AD 80-25-07 R1