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.

N3026WAsplund Jonas · Grand, MNBuilt 1979 · S/N 28R-7931126 N3026YEpss LLC · Tavernier, FLBuilt 1962 · S/N 18254026 N3027CPelayo Fernando · La Puente, CABuilt 1958 · S/N D-5692 N3027FSale Reported · Watford City, NDSale reported, pending cancellationBuilt 1966 · S/N 18257127 N3027RLedford James · Broad Run, VABuilt 1962 · S/N 320A0027 N3027TPlane Services LLC · Twin Falls, IDBuilt 1964 · S/N 320C0027 N30280Emery Clint L · Texarkana, ARBuilt 1973 · S/N 21059907 N30282Saucerman Equipment Leasing LLC · Indianapolis, INFirst renewal noticeBuilt 1987 · S/N E-2357 N3028NPryor Paul Robert · Carrollton, VABuilt 1979 · S/N 34-7970116 N3028QAllenspach Timothy L · Stillwater, MNBuilt 1967 · S/N 18258028 N3028WK2 Aviation LLC · Carroll, IABuilt 1973 · S/N E-465 N3028YStanton Tod J · Naperville, ILBuilt 1962 · S/N 18254028 N3029CHeyneman John M · Sheridan, WYS/N D-5694 N3029QOzarks Auto Show Inc · Hollister, MOBuilt 1967 · S/N 18258029 N3029TConsolidated Resource Imaging LLC · Grand Rapids, MIBuilt 1964 · S/N 320C-0029 N3029WLong Stephen D · Ontario, ORBuilt 1979 · S/N 28R-7931128 N302AZavoina Lawrence D Jr · Roanoke, TXBuilt 1969 · S/N 68-11055 N302BCG2 Leasing LLC · Cedar Spring, MIBuilt 1982 · S/N E-1982 N302BYAviation Homes LLC · Terrell, TXBuilt 2004 · S/N 0985 N302CDChadmatt Explorations LLC · Pensacola, FLBuilt 2004 · S/N 1076 N302CPJbl Aviation Group Inc · Houston, TXBuilt 2008 · S/N 3226 N302DGBluebird Aero LLC · Wilmington, DEBuilt 2006 · S/N 41565 N302GPInternational Air Services Inc Trustee · Carson City, NVS/N 21058682 N302JDNeoair LLC · Kingfisher, OKBuilt 2025 · S/N 10423 N302JHYang LLC · Lewisburg, WVBuilt 1962 · S/N CD-517 N302MCB & G Ventures LLC · Kalispell, MTBuilt 1973 · S/N 310Q0909 N302RPMccollough Randy F · Belton, TXBuilt 2004 · S/N 41051 N302SKHaynes Daniel R · New Braunfels, TXBuilt 1965 · S/N 310J-0036 N302SRRebel Aviation LLC · Ramsey, MNBuilt 2006 · S/N 2175 N302STManagement Support Services LLC · Naturita, COBuilt 1968 · S/N T210-0350 N302TDFl370 LLC · Northbrook, ILBuilt 2006 · S/N 1780 N302USolomon Mark Trustee · Wilmington, DEBuilt 1964 · S/N 18255529 N302WDivine John S III DBA · Myrtle Beach, SCS/N E-302 N302ZSutherland Derrick L · Ada, OKBuilt 1960 · S/N CD-201 N30301Brown Gregory R · Spotsylvania, VABuilt 1962 · S/N CD-450 N30303Registration Pending · Meeker, CORegistration pendingBuilt 1968 · S/N 17701181 N3030DBoardwalk Management LLC · Kalispell, MTBuilt 1999 · S/N E-3230 N3030FThirty Thirty Club · Lebanon, ORBuilt 1966 · S/N 18257130 N3030SBrewer Mike · Cameron Park, CABuilt 1978 · S/N E-1280 N3030YSamaniego Alejandro · Tucson, AZBuilt 1962 · S/N 18254030 N3031FAlderson John M · Venice, CABuilt 1966 · S/N 18257131 N3031LCavender Kelly P · Prosper, TXBuilt 1965 · S/N 310J0031 N3031QBrut N3031q · Los Angeles, CAFirst renewal noticeBuilt 1998 · S/N E-3196 N3031RSearch Gordon · Joliet, ILBuilt 1960 · S/N 39115 N3031YAir Repair Inc · Cleveland, MSBuilt 1962 · S/N 18254031 N3032ALynn University Inc · Boca Raton, FLS/N 3449294 N3032CPrice Michael J · Pulaski, NYS/N D-5687 N3032LBlue Sky Air Ventures LLC · Wilmington, DEBuilt 1999 · S/N EA-632 N3032QMitchell Michael A · Old Forge, NYBuilt 1967 · S/N 18258032 N3032WDebrouwer Isabelle Mc · Alpine, TXBuilt 1973 · S/N D-9525

Back to AD 2000-23-21