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.

N3483RCentury White Worldwide Inc · Casper, WYBuilt 1968 · S/N 18258783 N3483SHickey Bill J · La Veta, COBuilt 1964 · S/N 18255883 N3483UPool Robert Brooks · Lake Charles, LABuilt 1963 · S/N 18254883 N3483YGrimes William H · Seabrook, SCBuilt 1968 · S/N 18051983 N34843Radler Glenn E · Livingston, NJBuilt 1973 · S/N 17702037 N3484RTouch And Go Aviation LLC · Jackson, MNBuilt 1968 · S/N 18258784 N3484YSport Obermeyer Ltd · Aspen, COBuilt 1968 · S/N 18051984 N3485LEhalt Christopher J · Lester Prairie, MNBuilt 1967 · S/N U206-0785 N3485SThorp Contractors LLC · Vinita, OKBuilt 1964 · S/N 18255885 N3486UZhills Pilot LLC · Zephyrhills, FLBuilt 1963 · S/N 18254886 N3487SAscent Investments LLC · Kasota, MNS/N 18255887 N3487ULawser Ron · Townsend, MTBuilt 1963 · S/N 18254887 N3488MStrand Laird W · Appleton, WIBuilt 1978 · S/N 28R-7803173 N3488SBarbosa Javier · Edinburg, TXBuilt 1964 · S/N 18255888 N3489QPlane Progress LLC · Waterloo, IABuilt 1967 · S/N 320E-0089 N3489RKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1968 · S/N 18258789 N3489YHutchinson Earl F · Fairbanks, AKS/N 18502893 N348ABBledsoe Alvin · Horseshoe Bay, TXBuilt 1979 · S/N 18266934 N348ATCharitable Giving Center · Las Vegas, NVBuilt 2010 · S/N 0023 N348BWRegina Miller Group Inc · Santa Monica, CABuilt 2025 · S/N 11016 N348CBJmj Aviation LLC · Kalispell, MTBuilt 2007 · S/N 31-0033 N348CD348 Charlie Delta LLC · Ames, IABuilt 2007 · S/N 2389 N348LCChannel Larry E · Las Cruces, NMBuilt 2015 · S/N L2K-212 N348SKoritz Iowa Properties LLC · Key Colony Beach, FLBuilt 1970 · S/N D-9125 N348SBVector Victor Aviation LLC · Geneva, ILBuilt 2019 · S/N 4824 N348TFli Aero Ltd · New Lebanon, OHBuilt 1976 · S/N E-908 N348TSTuchman Holdings LLC · Englewood, NJBuilt 2011 · S/N 3800 N348ZPeters Edward S · Lake Placid, FLBuilt 1960 · S/N CD-235 N3490FRegistered aircraftBuilt 1966 · S/N 18257490 N3490RFreiberger Gary D · Fort Lauderdale, FLBuilt 1968 · S/N 18258790 N3490YRouse & Rouse-Houck LLC · Gunnison, COBuilt 1968 · S/N 18051990 N3491QOuter Marker Inc · Sandy, UTS/N 320E-0091 N3491SApollo Aviation Inc · Mound, MNFirst renewal noticeBuilt 1964 · S/N 18255891 N3491UMalchoff Kevin R · Lake View, NYBuilt 1963 · S/N 18254891 N3492QLadet William D · Las Vegas, NVS/N 320E-0092 N3492UMaligator Air LLC · Missoula, MTBuilt 1963 · S/N 18254892 N3493APapago Equipment LLC · Bayfield, COBuilt 1969 · S/N CD-1234 N3493SCola William Patrick · Colfax, CABuilt 1964 · S/N 18255893 N3494FParadise Aviation LLC · Shoreline, WABuilt 1966 · S/N 18257494 N3494QRodcon Aircraft Sales LLC · Kalispell, MTBuilt 1967 · S/N 320E-0094 N3494SLadder Livestock Company LLC · Savery, WYS/N 18255894 N3495LSaqul'Aq Air LLC · Coupeville, WABuilt 1967 · S/N U206-0795 N3495RC182 Flyers LLC · Las Cruces, NMS/N 18258795 N3495S3495s LLC · Prescott, AZBuilt 1964 · S/N 18255895 N3496AM-1 Medical LLC · Fairview Heights, ILBuilt 1969 · S/N CE-288 N3496YPincus Howard E · Grass Valley, CABuilt 1968 · S/N 18051996 N3497RWhitfield Derwin C · Picayune, MSBuilt 1968 · S/N 18258797 N3497SHenry Bruce N · Bloomfield, NMBuilt 1964 · S/N 18255897 N3497YBraden John C · Anchorage, AKBuilt 1968 · S/N 18051997 N3498FHole In The Sky Aviation LLC · Dallas, TXBuilt 1966 · S/N 18257498

Back to AD 2000-23-21