Skip to content

Registered aircraft · 85,620

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.

N15115Price Michael D · Shell Knob, MOBuilt 1972 · S/N 28-7305023 N15118Illinois Valley Flying Club Inc · Peru, ILBuilt 1972 · S/N 28R-7335023 N1511CBouton Vern H · Fairbanks, AKFirst renewal noticeBuilt 1953 · S/N 30211 N1511WFlorida Float Plane LLC · Coral Gables, FLBuilt 1972 · S/N TH-217 N15121Airborne Aviation LLC · Anchorage, AKFirst renewal noticeBuilt 1972 · S/N 28-7225589 N15122Dixson Joel T · Corpus Christi, TXBuilt 1972 · S/N 28-7225595 N15123Blackwood Aviation Services Inc · Orlando, FLBuilt 1972 · S/N 28-7305025 N15125Mallozzi Michael A · Albuquerque, NMBuilt 1972 · S/N 28R-7335025 N15126Registration Pending · Mc Caysville, GARegistration pendingBuilt 1972 · S/N 32-7300002 N1512CMolek Jon · Warren, OHBuilt 1953 · S/N 30212 N1512FJordan S G · Wasilla, AKBuilt 1965 · S/N 185-0833 N1512JHorning Timothy J · Saegertown, PABuilt 1967 · S/N 28-23906 N1512SIrwin Dennis R · San Diego, CABuilt 1962 · S/N D-6941 N1512WBryant John Mark · Knoxville, TNBuilt 1972 · S/N D-9332 N1512X4js Inc DBA Great Country Motors · Sun City, AZS/N 32R-7680002 N15132Lewis University · Romeoville, ILBuilt 1972 · S/N 28-7225597 N15134Roe Robert D Jr · Naples, FLBuilt 1972 · S/N 32-7300003 N15137Cart Caleb L · Eunice, LAS/N 32-7340016 N15138Lone Star Flight Museum · Houston, TXBuilt 1967 · S/N R1720133 N1513CSteffen Thomas E · Decatur, TXBuilt 1953 · S/N 30213 N1513SHoward Michael G · Slaughters, KYBuilt 1962 · S/N CD-473 N1513TLagemann Jeffrey P · Cocoa, FLBuilt 1972 · S/N 32-7240128 N1513XTurner Gary H · Big Stone Gap, VABuilt 1975 · S/N 28-7505237 N15140Anthony J Cariotte Jr · Holbrook, NYBuilt 1972 · S/N 28-7225598 N15141Murphy Jeffrey S · Mechanicsburg, PABuilt 1972 · S/N 28-7305027 N15142Dj Aviation LLC · Rio Vista, TXS/N 28-7305028 N15145Tri-Star Aviation Inc · La Porte, TXBuilt 1972 · S/N 34-7350026 N15148Brown Jerry Keith · Calera, ALBuilt 1972 · S/N 28-7225599 N1514BLilu LLC · Siloam Springs, ARBuilt 1988 · S/N CE-1276 N1514JBooher Greg F · Livingston, TNBuilt 1967 · S/N 28-23908 N1514MVaquera Moises C · Orland, CABuilt 1975 · S/N 18264359 N1514TTucker David J · Welch, OKBuilt 1972 · S/N 28-7225539 N1514XRabidou Gary R Jr · Lancaster, MABuilt 1975 · S/N 28R-7535305 N1514ZDierold Robert S · Carrollton, TXBuilt 1961 · S/N D-6832 N15151Smith Jared · Allendale, ILFirst renewal noticeBuilt 1972 · S/N 28R-7335029 N15152Meyer Kendra · Ankeny, IABuilt 1972 · S/N 28-7310015 N15153Kyzer Stacey A · Fort Mill, SCBuilt 1972 · S/N 28-7310016 N15159Piper One Five Niner Inc · Greenville, WIBuilt 1972 · S/N 28-7305029 N1515CMountain Taildraggers LLC · Aspen, COBuilt 1953 · S/N 30215 N1515FCain Ronald A · Slidell, TXBuilt 1965 · S/N 185-0844 N1515JMendenhall William R II · Beebe, ARS/N 28-23909 N1515MSurecraft LLC · Dover, DEBuilt 1988 · S/N CE-1304 N1515TSussman Steven T · Goshen, NYBuilt 1972 · S/N 28R-7235311 N1515WCenturionair LLC · Greenville, SCBuilt 1972 · S/N TH-218 N1515ZYanks Air Museum · Baldwin Park, CABuilt 1961 · S/N D-6831 N15160Western Aire Flying Club Ltd · Sparta, WIBuilt 1972 · S/N 28-7305030 N15169Stephens Brennan · Irving, TXBuilt 1972 · S/N 28R-7335032 N1516CSpotorno John Alan · Redwood City, CABuilt 1953 · S/N 30216 N1516JH&H Holding LLC · Tucson, AZBuilt 1967 · S/N 28-23911 N1516MWrubel David · Atlanta, GABuilt 1988 · S/N E-2459

Back to AD 98-21-21 R1