Skip to content

Registered aircraft · 54,015

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

N71114Aeropaws Aviation LLC · Front Royal, VABuilt 1968 · S/N 18259499 N71118Taf Aerial Services LLC · Beeville, TXS/N 18259501 N7111ABurgess Fred P · Titusville, FLBuilt 1956 · S/N 29211 N7111MPlatt Aaron Eugene · Heppner, ORBuilt 1958 · S/N 55411 N7111NAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1977 · S/N 17269101 N7111SDemaio John · Dillwyn, VABuilt 1976 · S/N 18265063 N7111TMesseder Thomas Alan Jr · Fredericksburg, VABuilt 1959 · S/N 46711 N7111XGoodwin Joseph N · Grass Valley, CABuilt 1961 · S/N 15059211 N71121Karmy Jeffrey R · Medford, ORBuilt 1968 · S/N 18259502 N71123Debusk Eric M · Columbus, INBuilt 1968 · S/N 18259503 N71124N71124 LLC · Waunakee, WIBuilt 1968 · S/N 18259504 N71126Overturf Andrew · Franklin, WIBuilt 1968 · S/N 18259505 N7112EAircraft Structural Repair Inc · Hamilton, MTBuilt 1959 · S/N 52112 N7112FHurst Richard H · Lometa, TXBuilt 1966 · S/N 15063712 N7112GHooper Walter E III · Spring City, TNBuilt 1969 · S/N 17258812 N7112SBridges Robert S · Friendswood, TXBuilt 1967 · S/N 15067812 N7112XKoplitz Wesley D · Oshkosh, WIBuilt 1961 · S/N 15059212 N7113Rotter Shane F · Olympia, WABuilt 1956 · S/N 33754 N71132Neale Bruce G · Joppa, ALBuilt 1968 · S/N 18259507 N711333 F Aviation LLC · Norwood, LABuilt 1968 · S/N 18259508 N71136Jones Harper L II · Pendleton, ORBuilt 1968 · S/N 18259509 N7113ATrail Richard L · Mccook, NEBuilt 1956 · S/N 29213 N7113MOgle Tyler E · Eufaula, OKFirst renewal noticeBuilt 1958 · S/N 55413 N7113QMiles Michael G · Hillsborough, NCBuilt 1972 · S/N 17260413 N71149Skydive Harbor Springs Inc · Charlevoix, MIBuilt 1968 · S/N 18259511 N7114ETlm Properties LLC · Gladewater, TXBuilt 1959 · S/N 52114 N7114FWernecke Thomas C · Southfield, MIBuilt 1966 · S/N 15063714 N7114MJohnson Mark A · Bellevue, IDBuilt 1958 · S/N 55414 N7114QSass Kenneth · Charlotte, NCBuilt 1972 · S/N 17260414 N7114SMuinos Jose M · York, PABuilt 1976 · S/N 18265064 N7114TMeyer Andrew J · Carter, SDBuilt 1959 · S/N 46714 N7114XKnutson Wayne R · Tioga, NDBuilt 1961 · S/N 15059214 N7115ARothenbusch Michael G · Tampa, FLBuilt 1956 · S/N 29215 N7115MSatanta Flying Service Inc · Satanta, KSBuilt 1958 · S/N 55415 N7115QMaggart Kenneth R · Lutz, FLBuilt 1972 · S/N 17260415 N7115T172 Club LLC · Olalla, WABuilt 1959 · S/N 46715 N71164Core Jerry M · Bishop, CABuilt 1968 · S/N 18259516 N71165Aggie Aero Enterprises LLC · Cleveland, TXBuilt 1968 · S/N 18259517 N7116QStogner Sarah E · Monahans, TXBuilt 1972 · S/N 17260416 N7116TMaierhoffer Henry F · Sylvania, GAS/N 46716 N7116XWeggel Roger · Fairbanks, AKBuilt 1961 · S/N 15059216 N71178Four Forces Of Flight LLC · Orlando, FLBuilt 1968 · S/N 18259521 N7117GBaker Brady B · South Hero, VTBuilt 1969 · S/N 17258817 N7117MFly 2 Hope LLC · Hilliard, FLBuilt 1958 · S/N 55417 N7117TOrtega Rolando J · Davie, FLBuilt 1959 · S/N 46717 N7117XBoldog Sandor Alex · Andalusia, ALBuilt 1961 · S/N 15059217 N71187Watermeier Daniel W · Syracuse, NEBuilt 1968 · S/N 18259524 N71188Youderian Kenneth E · Coupeville, WABuilt 1968 · S/N 18259525 N7118GRegistration Pending · Spruce Pine, ALRegistration pendingBuilt 1973 · S/N 15074613 N7118QMartin Stephen T · Green Cove Springs, FLBuilt 1972 · S/N 17260418

Back to AD 87-20-03 R2