Registered aircraft · 47,138

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.

N3218URadford Tara Lynn · Elmira Heights, NYBuilt 1963 · S/N 18254618 N3218XMjm Flying LLC · Traverse City, MIBuilt 2000 · S/N E-3358 N3218YCollins Marcus E Jr · Camilla, GABuilt 1962 · S/N 18254218 N3219KHeritage Flight Museum · Burlington, WABuilt 1968 · S/N 68-6892 N3219SYogodzinkski Steve M · Amberson, PAS/N 18255719 N321AAltman Mchael A · Austin, TXBuilt 1957 · S/N D-4962 N321AYCameron Kari L · Ashland, ORBuilt 1973 · S/N 18261756 N321AZBuilders Aviation LLC · Algona, IABuilt 2003 · S/N 0508 N321BValdez Aero Inc · Wilmington, DEBuilt 1957 · S/N D-4939 N321BGItinerant Orl LLC · Columbia, SCBuilt 2005 · S/N 1311 N321BLWalls Bruce · Middletown, OHBuilt 1981 · S/N P21000792 N321BSBrown Gregory N Trustee · Flagstaff, AZBuilt 1978 · S/N 18266765 N321BURegistration Pending · Tavares, FLRegistration pendingBuilt 1966 · S/N 310K0184 N321BWAero Marine Inc · Westland, MIBuilt 1966 · S/N D-8343 N321BXBravo Xray LLC · Gainesville, FLBuilt 2007 · S/N 41799 N321CEMaroon Sky LLC · Navasota, TXBuilt 1981 · S/N 421C1225 N321CFTekswork Aviation LLC · London, KYBuilt 2002 · S/N 0304 N321CHSmith James Christian · Rockport, TXBuilt 1962 · S/N 21058061 N321CNInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 28R7803166 N321CXPollak Steven D · Cincinnati, OHBuilt 2022 · S/N 71443 N321DBDc Aviation Maintenance Inc · Bryant, ARBuilt 1978 · S/N CE-797 N321DDGreene Jonathan U · Pompano Beach, FLBuilt 1980 · S/N TJ-278 N321DGAdkison Edy P · Riverside, CABuilt 1969 · S/N 21059201 N321DSYoung Winston Shannon Jr · Del Rio, TXBuilt 1958 · S/N D-5661 N321DWJsj LLC · Wilmington, DEBuilt 1979 · S/N 310R1823 N321EEVermont Skydiving Adventures Inc · Addison, VTBuilt 1956 · S/N 33582 N321EKCielo Holdings Group LLC · Ormond Beach, FLBuilt 2024 · S/N 10172 N321ETVlt Aviation LLC · Tampa, FLBuilt 2025 · S/N 10940 N321FFInternational Air Services Inc Trustee · Carson City, NVBuilt 2008 · S/N 31-0120 N321FLSkywalker Aviation LLC · Saint Paul, MNBuilt 2009 · S/N 3392 N321GKBrown Water Associates LLC · Monticello, FLBuilt 2015 · S/N 4290 N321GSXenu Aircraft LLC · Hatfield, PABuilt 2018 · S/N 1675 N321HDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 414-0625 N321HBYosemite Axe Throwing · North Fork, CABuilt 2015 · S/N 4257 N321HTPartnairs LLC · Lake Charles, LABuilt 2015 · S/N 4246 N321JAJa Consulting LLC · Delray Beach, FLBuilt 2025 · S/N 10674 N321JHSkidmore Gary DBA · Terreton, IDBuilt 1978 · S/N 414A0063 N321JJJayjet Private Aircraft Charter LLC · Swanton, OHBuilt 2004 · S/N 1113 N321JMEo Liquidation Inc · Whitehouse Station, NJBuilt 2019 · S/N 1902 N321JPAzure Skyes Holdings LLC · Poulsbo, WABuilt 1980 · S/N 18504166 N321JRAcademy Aviation Services LLC · Cedar Park, TXBuilt 1982 · S/N EA-289 N321JTPcss Aviation LLC · New Albany, MSBuilt 2001 · S/N EA-670 N321JWTahoe Blue Medical LLC · Incline Village, NVBuilt 2026 · S/N 11341 N321JZGolden Gate Meat Company Inc · Richmond, CABuilt 2026 · S/N 11432 N321KBBecker Kevin P · Orange, CABuilt 1977 · S/N 33701782 N321KKPanoche Aviation Co LLC · Fresno, CABuilt 1979 · S/N 18267488 N321LGLaughing Gull Aviation Inc · Fort Lauderdale, FLBuilt 1978 · S/N 21062769 N321LLTwocarols LLC · San Francisco, CABuilt 2022 · S/N 8704 N321LTTailwinds & Tanlines LLC · Fort Worth, TXBuilt 2019 · S/N 2009 N321MDBrown Melvin W Jr Trustee · Shady Shores, TXBuilt 2006 · S/N 29-0470

Back to AD 2000-23-21