Skip to content

Registered aircraft · 6,915

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:97-01-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:97-01-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:97-01-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:97-01-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:97-01-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:97-01-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.

N38983N38983 LLC · Fort Worth, TXBuilt 1977 · S/N 32R-7780494 N38984Registered aircraftS/N 32R-7780495 N38991Jaquez Francisco P · Corona, NYBuilt 1977 · S/N 28R-7703291 N38995Baxter Donald J · Dallas, TXBuilt 1977 · S/N 28R-7703292 N38997Blg Air Inc · State College, PABuilt 1977 · S/N 32R-7780496 N38999Raymond O Bentley Inc · Winter Haven, FLBuilt 1977 · S/N 32R-7780497 N3899TKaragiannis Nikitas · Fort Worth, TXBuilt 1967 · S/N 28R-30230 N38AGBaxter Kyle W · Tumwater, WABuilt 1959 · S/N 24-1259 N38TXGlinn Andrew T · Keystone, NEBuilt 1977 · S/N 28R-7703297 N38WJFerguson Scott D · Valparaiso, INBuilt 1975 · S/N 28R-7535327 N3900TNopat LLC · North Charleston, SCBuilt 1967 · S/N 28R-30232 N3904XMoore Jeremy E · Baton Rouge, LABuilt 1975 · S/N 28R-7535347 N3905TSmooth Air LLC · Tampa, FLBuilt 1967 · S/N 28R-30239 N3908TAustin Christopher · Dayton, NVBuilt 1967 · S/N 28R-30243 N3908XDeutsch Chad A · Evansdale, IAS/N 34-7570308 N3909TAnnis Aviation LLC · Gray, GABuilt 1967 · S/N 28R-30244 N3909XSmith Aero Inc · Huntington Beach, CABuilt 1975 · S/N 34-7670001 N390WWalter Paul F · Milwaukee, WIBuilt 1970 · S/N 39-39 N3910TSpeelman Jonathan D · Stockton, CABuilt 1967 · S/N 28R-30245 N3911TMartin Aviation Services LLC · Bay City, MIS/N 28R-30246 N3913TPetit Randy F Jr · Ama, LABuilt 1967 · S/N 28R-30249 N3913XDesert Flight Academy Inc · Henderson, NCBuilt 1975 · S/N 28R-7535350 N3914TBias Lee · Weston, FLS/N 28R-30961 N3914XLechene Aviation LLC · Indiana, PABuilt 1975 · S/N 28R-7535351 N3916TChnupa David Scott · Fishers, INBuilt 1967 · S/N 28R-30252 N3917THarrington-Zink Kristopher Michael · Port Richey, FLBuilt 1967 · S/N 28R-30253 N3918XHorton Gregory L · Moorpark, CAS/N 28R-7703001 N391WHSheppard Harold Jr DBA · Riverton, WYBuilt 1968 · S/N 28R-30934 N3920XBennett Barry B · El Cajon, CABuilt 1975 · S/N 28R-7535352 N3921TLittlehailes Roderick A Trustee · Solvang, CAS/N 28R-30258 N3921XBurger Paul D · Cypress, TXBuilt 1975 · S/N 28R-7535353 N3923XFerriero Bruce C · Danvers, MABuilt 1975 · S/N 28R-7535354 N3924TRaw Racing Inc · Puyallup, WABuilt 1967 · S/N 28R-30262 N3925TElevation Air LLC · Amelia, OHBuilt 1967 · S/N 28R-30263 N3926TNewton Aviation LLC · Atlanta, GAFirst renewal noticeBuilt 1967 · S/N 28R-30264 N3928MSalter James A · San Luis Obispo, CABuilt 1978 · S/N 28R-7803201 N3928TBarnett Rodney · Rockwood, TNBuilt 1967 · S/N 28R-30267 N3928XVanness Aviation LLC · Lawton, NDBuilt 1975 · S/N 28R-7535355 N3929FRadaskiewicz Mark D · Gilbert, AZBuilt 1976 · S/N 32R-7680420 N3930XWilson Martin E · Arlee, MTBuilt 1975 · S/N 34-7570317 N3931THall Charles H · Belleville, MIBuilt 1967 · S/N 28R-30270 N3932TAhles David R · Tellico Plains, TNBuilt 1967 · S/N 28R-30271 N3932XCarbon Six LLC · San Diego, CAS/N 28R-7535356 N3936TGreen Castle Aero Club Ltd · Oxford, IABuilt 1967 · S/N 28R-30277 N3939TDespins David R · Gray, MES/N 28R-30281 N393TBTom Brown Consulting LLC · Ave Maria, FLBuilt 1969 · S/N 30-1874 N3942TAuburn Valley LLC · Farmington, MNBuilt 1967 · S/N 28R-30285 N3943XSuberg Valerie G · Windsor, CABuilt 1975 · S/N 28R-7535362 N3944XClark Nicholas J · Wilmington, DEBuilt 1975 · S/N 28R-7535363 N39457Pro-Aire Inc · Chisago City, MNBuilt 1978 · S/N 28R-7837297

Back to AD 97-01-01 R1