Skip to content

Registered aircraft · 47,133

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

N42148Rizzo Michael R · Yorba Linda, CABuilt 1968 · S/N 18258874 N42150Custom Air Solutions LLC · Broadway, VABuilt 1968 · S/N 18258875 N42151Foster Floyd W · Lyon, MSBuilt 1968 · S/N 18258876 N42154Datil Fly Inc · Saint Augustine, FLBuilt 1968 · S/N 18258878 N42159Cutruzzula Arthur · Pittsburgh, PABuilt 1968 · S/N 18258881 N4215SHolliday Bryan E · Flower Mound, TXBuilt 1976 · S/N CE-678 N42164Bush David W · Camden, NCBuilt 1968 · S/N 18258882 N4216QFoulkrod Freebird LLC · Buda, TXBuilt 1975 · S/N U20603040 N42175Roberts Jason L · Crossville, TNBuilt 1968 · S/N 18258885 N42176N42176 LLC · Lynn Haven, FLBuilt 1968 · S/N 18258886 N42177Skydive Baltimore LLC · Churchville, MDBuilt 1968 · S/N 18258887 N42182Schaible John F · Palmerton, PABuilt 1973 · S/N 18052323 N42184Designed Cabinets · Lakeville, MNBuilt 1968 · S/N 18258890 N42188Verge Gregory J · Lynnwood, WABuilt 1968 · S/N 18258891 N4218ARed Skye 52 LLC · Port Orange, FLS/N 52-8271A N42198Johnson Steve · Belen, NMBuilt 1968 · S/N 18258894 N421AGone Flyin LLC · Wilmington, DEBuilt 1981 · S/N 421C1211 N421BJRegistered aircraftBuilt 1968 · S/N TC-1057 N421CShadow Cat Aviation LLC · Fitchburg, WIBuilt 2002 · S/N 0434 N421CBDegrado Aviation LLC · Sedalia, COBuilt 2021 · S/N 2363 N421CDTarsky Project LLC · Panama City Beach, FLBuilt 2006 · S/N 1791 N421DNDel Mar College · Corpus Christi, TXBuilt 1968 · S/N 421-0146 N421DWLandman William L · Snowmass, COBuilt 1979 · S/N 28R-7931044 N421HSQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N 421C0621 N421NGcmj Air LLC · Naples, FLBuilt 2024 · S/N 10103 N421NMWings Over The Rockies Air & Space Museum · Denver, COBuilt 1961 · S/N G-720 N421PWMead Lawrence C Trustee · Powell, OHBuilt 2002 · S/N E-3466 N421SWProuty Eric A · San Jose, CABuilt 1969 · S/N CE-256 N421TMcconnell Raymond F · Stratton, COBuilt 1960 · S/N CD-278 N421TWHeslin Jon L · Sutton, MABuilt 1978 · S/N 18266268 N421YKearns Homer C III · Granbury, TXBuilt 1977 · S/N 18266133 N42202Palmer Charles L · Huntington Beach, CAFirst renewal noticeBuilt 1968 · S/N 18258895 N42204Conservation Aviation LLC · Washington, DCBuilt 1968 · S/N 18258897 N42206Jones Brian William · Portland, ORBuilt 1968 · S/N 18258899 N42209Smith Patrick G · Wenatchee, WABuilt 1968 · S/N 18258901 N4220QWhitefish Aero Services LLC · Crosslake, MNBuilt 1973 · S/N 18502225 N42219Beck Daniel Joseph · Tuscaloosa, ALBuilt 1968 · S/N 18258908 N42232Wheater Eric Alexander · King George, VABuilt 1968 · S/N 18258914 N42234Vp Niagara Aviation LLC · Niagara Falls, NYS/N 18258916 N42242Beats A Flush LLC · San Diego, CABuilt 1968 · S/N 18258920 N42247Kratz Jeffrey B · Seattle, WABuilt 1973 · S/N 18052330 N4224KDickson Robert T · Charlotte, NCBuilt 1948 · S/N NAV-4-1224 N42251Ada Forestry Division · Malvern, ARBuilt 1968 · S/N 18258926 N42261Shenandoah Skies LLC · Harrisonburg, VABuilt 1968 · S/N 18258930 N42262R And E Aviation LLC · Laurel, MSBuilt 1968 · S/N 18258931 N42267Eischens William L · Alexandria, VABuilt 1968 · S/N 18258934 N4226QVolatile Aero Ventures LLC · Boulder City, NVBuilt 1976 · S/N U20603041 N42275Nelson Frank H · Tuscaloosa, ALBuilt 1968 · S/N 18258937 N42279Keller Mark D · Ellensburg, WABuilt 1968 · S/N 18258940 N42280Altitude Addiction LLC · Harker Heights, TXBuilt 1968 · S/N 18258941

Back to AD 2000-23-21