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.

N42700Van Matre Thomas A Jr · Mineola, TXBuilt 1973 · S/N 18052371 N42704White Dog I LLC · Bend, ORBuilt 1968 · S/N 18259149 N42705Henry James A · Fresno, CABuilt 1968 · S/N 18259150 N42707Management Assistance Group LLC · Hamilton, NJBuilt 1968 · S/N 18259152 N42712Adams William Kelly · Tulia, TXBuilt 1968 · S/N 18259155 N42713Prater Bobby D · Grand Ledge, MIBuilt 1968 · S/N 18259156 N42714Crouch Jeffrey Lane Sr · Rockingham, NCBuilt 1968 · S/N 18259157 N42715Coleman Robert B · San Francisco, CABuilt 1968 · S/N 18259158 N42718Circle K Bar LLC · Ardmore, OKBuilt 1968 · S/N 18259161 N4271SVk Aviation LLC · Jennings, LABuilt 1976 · S/N E-944 N42725Tepper Jeremy A · Vail, AZBuilt 1968 · S/N 18259165 N4272CKamps Air LLC · Grand Rapids, MIBuilt 1982 · S/N 414A0849 N4272QKeech Mark A · Fairbanks, AKBuilt 1976 · S/N U20603042 N4272SSchechter Stuart · Great Neck, NYBuilt 1976 · S/N D-9959 N42732Wampole David R · Miami, FLBuilt 1968 · S/N 18259169 N4273RYuknis Leonard F · Wasilla, AKBuilt 1976 · S/N 18502924 N42742Still Russell F · Cumming, GABuilt 1968 · S/N 18259171 N42748Crowe Tanner L · Anchorage, AKBuilt 1968 · S/N 18259173 N42754Shade Donald S · Big Bear City, CABuilt 1968 · S/N 18259175 N42758Carver Steven R · Scottsville, KYS/N 18259177 N42763Vf 126 Aviation LLC · Chicago, ILBuilt 1968 · S/N 18259178 N427653 B Farms Inc · Pinetown, NCBuilt 1968 · S/N 18259180 N42766Jessee Robert A · Winter Haven, FLBuilt 1968 · S/N 18259181 N42768Horn Terry D · Sharpsburg, GAS/N 18259183 N42770Barthelette Kenneth E · Pawleys Island, SCBuilt 1968 · S/N 18259184 N42777Cantwell Patrick W · San Francisco, CABuilt 1968 · S/N 18259185 N4277BHale Barbara M · Oxnard, CABuilt 1977 · S/N R1722556 N4277VBoyd William L · Hillsboro, ORS/N 18635 N42792Baxter Adam W D · Anchorage, AKBuilt 1968 · S/N 18259193 N4279SSteinbacher Deane E · Waterford, WIBuilt 1976 · S/N E-948 N427ARDouglass Aviation LLC · Franktown, COBuilt 2015 · S/N 1109 N427ATMockingbird LLC · Bloomington, INBuilt 2004 · S/N 0954 N427BDNostra Aeris LLC · Gassville, ARBuilt 1991 · S/N EA528 N427CAChippewa Aerospace Inc · Gainesville, FLBuilt 1976 · S/N 310R0653 N427CEVwd Aviation LLC · Bozeman, MTBuilt 2025 · S/N 10743 N427CWRural Orthopedic Care LLC · Ardmore, OKBuilt 2001 · S/N E-3400 N427DWFlyin Phar LLC · Salt Lake City, UTBuilt 1979 · S/N TK-113 N427FStingray Motors LLC · Kansas City, MOS/N 3RX 157 N427GBBoies Guy J · Mason, TXBuilt 1973 · S/N 18262174 N427HHSinopoli Albert L · Friendswood, TXFirst renewal noticeBuilt 2007 · S/N E-3770 N427HPBohannon Brian · Prosper, TXBuilt 2005 · S/N 1528 N427JRWhite James L · Belleair, FLBuilt 2005 · S/N LIV-436 N427JTCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11637 N427KDRegistered aircraftBuilt 2019 · S/N 1967 N427KGWhite James J IV · Conroe, TXBuilt 2008 · S/N 3068 N427KMAviation Advantage LLC · Phoenix, AZBuilt 1974 · S/N TC-1818 N427LCP D Capital LLC · San Diego, CABuilt 2006 · S/N 1626 N427LLForrest Jeffrey H · Bloomfield Hills, MIBuilt 1977 · S/N CE-679 N427PASeigars Richard M · Port Orange, FLBuilt 2008 · S/N 411096 N427PWLangford Stephen C · York, SCBuilt 1976 · S/N D-9850

Back to AD 2000-23-21