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.

N20393Nextgen Flying LLC · Pigeon Forge, TNBuilt 1972 · S/N 17261253 N20398Laron W Hall · Hurricane, UTBuilt 1972 · S/N 17261258 N20399Total Flight Aircraft Leasing LLC · Apex, NCBuilt 1972 · S/N 17261259 N2039RChurch Of The Word International Inc · East Earl, PABuilt 1964 · S/N 18255239 N2039VOwen Michael · Port Charlotte, FLBuilt 1978 · S/N E-1375 N2039WWitt Ted C · Castle Rock, COBuilt 1965 · S/N CD-969 N203AKHornyak Ryan J · Girard, PABuilt 1957 · S/N 50096 N203BNCarlson Curt · Lake Havasu City, AZBuilt 1980 · S/N 310R2101 N203BWAlexander Katherine · Fishers, INBuilt 1976 · S/N 28R-7635113 N203CCMonarch Air LLC · Dewitt, MIBuilt 1979 · S/N 28-7911110 N203DAerotres LLC · Lakeville, MNBuilt 2020 · S/N 2881425 N203DMCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1966 · S/N 27-3461 N203EAEtheredge Mark · Pell City, ALBuilt 2023 · S/N 28020118 N203EPAlvarez Bernardo · Clayton PanamaNon-citizen corporation, flight hours not reportedBuilt 1980 · S/N 18267546 N203FSpace Coast Aircraft Co · Merritt Island, FLBuilt 1984 · S/N 288416083 N203GTUniversity Of Michigan Flyers Inc · Ann Arbor, MIBuilt 1979 · S/N 17272403 N203MABuckau Michael S · Costa Mesa, CABuilt 1970 · S/N 28-26738 N203MDSinsaja Holdings LLC · Sheridan, WYBuilt 1976 · S/N 28-7625251 N203PLHhj & Rbj Holdings LLC · Prattville, ALBuilt 1976 · S/N D-9898 N203PWWood Philip A · Stamford, CTS/N 1281 N203RTKinzer Richard J · Piney Flats, TNBuilt 1962 · S/N D-6931 N203SCWesley Robert J · Chuckey, TNBuilt 1966 · S/N 30-1118 N203SJCorrado Christopher · Newton, NJS/N 32-40037 N20402Fosdick Kenneth E · Plymouth, MABuilt 1972 · S/N 17261261 N20404Air Data Solutions LLC · Natchitoches, LABuilt 1972 · S/N 17261263 N20405Buffalo Wings LLC · Overland Park, KSS/N 17261264 N20406Sp Airparts LLC · Moscow, IDS/N 17261265 N2040ASchultz Philip W · Lancaster, CABuilt 1969 · S/N D-9024 N2040CWatson Anthony A · Midlothian, TXBuilt 1977 · S/N E-1135 N2040GFinal Forge LLC · Blountville, TNBuilt 1978 · S/N E-1380 N2040PTrb Aviation LLC · Fredericksburg, VABuilt 1978 · S/N D-10183 N2040REco Flite Service Inc · Lake Elsinore, CABuilt 1964 · S/N 18255240 N2040UGillim Parvin D · Sheridan, INBuilt 1978 · S/N E-1381 N2040XBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 18256140 N2040YCappel Eric H · Satellite Beach, FLBuilt 1978 · S/N D-10181 N20413Colton Terence J · Point Roberts, WABuilt 1972 · S/N 17261270 N20418Pierce Scott W · Fredonia, NYBuilt 1972 · S/N 17261273 N2041DLyman Eric J · Upland, CABuilt 1952 · S/N D-3393 N2041GSmith Stacey · Malakoff, TXS/N 51341 N2041PManke Brian W · Chesapeake, VABuilt 1978 · S/N CE-821 N2041RBlair Darrell E · Trinity, NCBuilt 1969 · S/N 28-5440 N2041WJimenez John D · San Antonio, TXS/N D-7982 N2041ZBlue Mesa LLC · Bend, ORBuilt 1978 · S/N TE-1144 N20420N83993 LLC · Cherry Hill, NJBuilt 1972 · S/N 17261275 N20421West Michigan Flying Club Inc · Norton Shores, MIBuilt 1972 · S/N 17261276 N20423Lowcountry Flight LLC · Johns Island, SCBuilt 1972 · S/N 17261278 N20427Sleight Craig R · Prineville, ORBuilt 1972 · S/N 17261280 N2042BHasemann James M · Gaithersburg, MDBuilt 1978 · S/N D-10185 N2042CDms Leasing Co LLC · Las Vegas, NVS/N TD-219 N2042ESmith James E Trustee · Kalispell, MTS/N TC-2188

Back to AD 98-21-21 R1