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.

N3744DMorcom Ronald W Jr · Stanwood, WABuilt 1957 · S/N 34444 N3744GValiair Limited Co Trustee · Casper, WYBuilt 1977 · S/N 310R0909 N3745PRiviera Aircraft Inc · Lewes, DEBuilt 1978 · S/N P21000052 N3745UAnglemyer Mark · Piketon, OHBuilt 1963 · S/N 18255145 N3746Nickravesh Niknam J · Saratoga, CABuilt 1975 · S/N U20602818 N3746UUltimate Internet Access Inc · Wrightwood, CABuilt 1963 · S/N 18255146 N3746YWeed James A · Suwanee, GABuilt 1963 · S/N 21058246 N3747CS I Air Inc · Dover, DEBuilt 1975 · S/N 414-0818 N3747QWolff Charles L · Pensacola, FLBuilt 1967 · S/N TE-307 N3747TAir Force One LLC · Coral Springs, FLBuilt 2005 · S/N 1328 N3747YCenturion Aviation Nevada LLC · Sparks, NVBuilt 1963 · S/N 21058247 N3748DPetersen Jacob R · Wasilla, AKBuilt 1957 · S/N 34448 N3748HVoth Michael K · Lynchburg, VABuilt 1963 · S/N 21058248 N3748QThoendel Jason · Saint Charles, MOBuilt 1967 · S/N D-8411 N3748UChristy Allen C · Farmington, NMBuilt 1963 · S/N 18255148 N3749YWestwind Homes Inc · Twin Falls, IDBuilt 1963 · S/N 21058249 N374CDN374cd LLC · Goffstown, NHBuilt 2004 · S/N 1174 N374DNChadbourne Daniel I Jr · Anchorage, AKBuilt 1978 · S/N P3370326 N374RLDeep Blue Spring LLC · Doral, FLBuilt 2022 · S/N 9026 N374TOtt James D · Kilgore, TXBuilt 1966 · S/N D-8165 N374TAVintage Aero Inc · Brandon, FLBuilt 1974 · S/N 310Q1105 N374TTTyphoon Holdings LLC · Valdosta, GABuilt 2021 · S/N 2438 N374WHLr Freedom Air LLC · Tallahassee, FLBuilt 2025 · S/N 10746 N374ZZulu Golf LLC · Yukon, OKBuilt 1960 · S/N D-6554 N3750YMurphy Mark · Belleair, FLBuilt 1963 · S/N 21058250 N3752CMiller Robert G · Clear Lake, IAS/N 414-0819 N3752QProp Setters LLC · Memphis, TNBuilt 1967 · S/N CD-1084 N3752URegistered aircraftBuilt 1963 · S/N 18255152 N3753YWolfe Christopher D · Gilbert, AZBuilt 1963 · S/N 21058253 N3754DEckard Eric M Trustee · Wasilla, AKBuilt 1957 · S/N 34454 N3754YSullivan Eugene M · Cotter, ARBuilt 1963 · S/N 21058254 N3755UHendrickson Justin R · Twin Falls, IDBuilt 1963 · S/N 18255155 N3755YCecil Enterprises LLC · Gig Harbor, WABuilt 1963 · S/N 21058255 N37566Aviation Specialty Services LLC · Beaufort, NCBuilt 1967 · S/N 337M0157 N3756DAnderson Daren J · Almond, WIS/N 34456 N3756UKlinger Cattle Co Inc · Friona, TXBuilt 1958 · S/N 51263 N3756XStephens Tanner B · Palmer, AKBuilt 1968 · S/N 21059075 N3758CDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N 414-0839 N3758DStrother John G · Kenai, AKBuilt 1957 · S/N 34458 N3758QHalley Douglas H · Shelton, CTBuilt 1967 · S/N CD-1071 N3759QJ & C Companies LLC · Mesa, AZBuilt 1967 · S/N D-8394 N3759YManagement Support Services LLC · Naturita, COBuilt 1963 · S/N 21058259 N375AJGolden Calf Company LLC · Bloomer, WIBuilt 2010 · S/N 0041 N375BMBlotsky Jim · Fargo, NDBuilt 2024 · S/N 10092 N375CDAtlantic Marine Construction Co Inc · Virginia Beach, VABuilt 2005 · S/N 1461 N375CWN375cw LLC · Fort Smith, ARFirst renewal noticeBuilt 2017 · S/N 1487 N375DBEight Aviation LLC · Greenwood Village, COS/N 2331 N375FDepartment Of The Interior · Boise, IDBuilt 1980 · S/N U20605750 N375HPCraig E Rappe · Wasilla, AKBuilt 1976 · S/N 18503235 N375HWWallace Charles · Fayetteville, ARBuilt 1963 · S/N 21058251

Back to AD 2000-23-21