Skip to content

Registered aircraft · 85,616

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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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.

N12821Hayslett Norman L · Roscoe, MOBuilt 1973 · S/N 17262290 N12822Courtney Aviation LLC · Columbia, CABuilt 1973 · S/N 17262291 N1282FRainbow River Lodge Aviation LLC · Alpine, UTS/N 18502806 N1282URutledge James K Trustee · Colfax, CABuilt 1976 · S/N 17266977 N1282ZBrickhouse Aviation LLC · Franklin, TNBuilt 1961 · S/N D-6711 N12830All Sports Aviation LLC · Spokane, WABuilt 1973 · S/N 17262296 N12831Bryant Kevin L · Terry, MSBuilt 1973 · S/N 17262297 N12833Kling Aviation Inc · Friendswood, TXBuilt 1973 · S/N 17262299 N12834High Flight Academy LLC · Allison Park, PABuilt 1973 · S/N 17262300 N12836Schlemmer Diane · Roswell, GABuilt 1973 · S/N 17262301 N1283UAtutis Michael F · Baldwinsville, NYBuilt 1976 · S/N 17266978 N12840Lanier Aviation LLC · Cleveland, GABuilt 1973 · S/N 17262304 N12849Ripa Christopher J · East Harwich, MABuilt 1973 · S/N 17262311 N1284NAbnc Air LLC · Wellington, FLS/N 28-7405076 N1284TWhite Wayne A · Loyalton, CABuilt 1959 · S/N 52016 N1284WBethel Don G · Bossier City, LABuilt 1967 · S/N 28R-30304 N1284ZDubose Alexander R · Durham, CABuilt 1961 · S/N TD-458 N1285FWill Rittner E · Sevierville, TNBuilt 1975 · S/N 18502809 N1285ROrbit Aviation LLC · Lakewood, CAS/N 31026 N1285YBartosh Larry M · Abbott, TXBuilt 1963 · S/N 17251038 N1285ZRivera Luis Jr · Spring, TXBuilt 1961 · S/N TC-100 N12860Solis Aviation LLC · Carroll, OHBuilt 1973 · S/N 17262319 N12865Flyright Aviation LLC · Columbus, OHBuilt 1973 · S/N 17262324 N12866Holmes Charles Trustee · Fort Madison, IABuilt 1973 · S/N 17262325 N12867Palm Grove Development Inc · Gray, GABuilt 1973 · S/N 17262326 N1286DPolicani Desmond M · Tacoma, WABuilt 1951 · S/N 19862 N1286FTaylor Aviation Inc · Mazama, WAFirst renewal noticeBuilt 1975 · S/N 18502810 N1286GRegistered aircraftS/N 28-7990076 N1286THeffelfinger Paul D · Seven Valleys, PABuilt 1972 · S/N 28-7205277 N12871Bemidji Aviation Services Inc · Bemidji, MNBuilt 1973 · S/N 17262330 N12872Advanced Aviation And Aircraft Rental LLC · Lawrenceville, GABuilt 1973 · S/N 17262331 N12874Mentone Flying Club Inc · Rochester, INBuilt 1973 · S/N 17262333 N12875Career Flight Training And Aircraft Rental LLC · Naples, FLBuilt 1973 · S/N 17262334 N12876Aerolanding LLC · Enterprise, ALBuilt 1973 · S/N 17262335 N12878M&M Bear Necessities LLC · Newellton, LABuilt 1973 · S/N 17262337 N1287TBelle Casa Aero LLC · Tarpon Springs, FLBuilt 1972 · S/N 32-7240111 N1287UTrekraken Aviation LLC · Scottsdale, AZBuilt 1976 · S/N 17266981 N12880Aerial Holdings LLC · Lewes, DEBuilt 1973 · S/N 17262339 N12883Rpm Aero LLC · Lincolnwood, ILBuilt 1973 · S/N 17262340 N12884Registered aircraftBuilt 1973 · S/N 17262341 N12885Above & Beyond Aviation LLC · Sandy Hook, CTBuilt 1973 · S/N 17262342 N12886Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17262343 N12887Slipstream Aviation LLC · Calera, ALBuilt 1973 · S/N 17262344 N1288ALaminar Training Solutions LLC · Murrieta, CABuilt 1983 · S/N 24-1364 N1288DConner Brent F · Medford, ORBuilt 1951 · S/N 19861 N1288HFly By Knight Inc · Hammond, LABuilt 1976 · S/N 28-7716011 N1288SFrench Oil Co · Midland, TXBuilt 1976 · S/N 18264855 N1288ZWeber Colleen M · Waterford, WIBuilt 1961 · S/N CD-335 N12893Weiss Lyle D · Faith, SDBuilt 1973 · S/N 17262348 N12897Foothill Aircraft Sales & Service Inc · Upland, CABuilt 1973 · S/N 17262352

Back to AD 98-21-21 R1