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.

N395KGBatsche George M Jr · Tampa, FLFirst renewal noticeBuilt 1981 · S/N 348133030 N395LMMj&J LLC · Dodge City, KSBuilt 2005 · S/N 1395 N395MRParamount Risk Mgmt And Insurance Scvs LLC · San Luis Obispo, CAS/N 29-0498 N395SAFmco Promotions Inc · North Little Rock, ARBuilt 2000 · S/N E-3313 N395SBPc-Tronix Inc · Mechanicsburg, PABuilt 2007 · S/N 1769 N395STCm Golf LLC · Sacramento, CABuilt 1973 · S/N 18262665 N395ZSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1960 · S/N D-6566 N3960YSeals Clinton F · Warren, ORBuilt 1964 · S/N 21058460 N39611Boon & Company Aviation LLC · Charlotte, NCBuilt 1978 · S/N 28R-7803357 N3961YSmith Edward C · Lecompton, KSBuilt 1964 · S/N 21058461 N3962DMalone Parachute Club Inc · Williston, VTBuilt 1957 · S/N 34662 N3962GJoe Sanchez Farms Inc · Walnut Grove, CABuilt 1967 · S/N U206-0962 N3962XPureflight Aviation Training LLC · Newberg, ORS/N 34-7670007 N3963DMaplewood Flying Association Inc · Dorset, VTBuilt 1957 · S/N 34663 N39655Weather Modification LLC · Fargo, NDBuilt 1978 · S/N 34-7870403 N3967YBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 21058467 N3968DFallon Jeffrey C · Berlin, MABuilt 1957 · S/N 34668 N3968QTundra Wings Ministries · Wasilla, AKBuilt 1975 · S/N U20603037 N3968XMoorhead Equipment LLC · Belton, SCBuilt 1975 · S/N 34-7670009 N3968YDetray Michael S · Roy, WAFirst renewal noticeBuilt 1964 · S/N 21058468 N3969DNeal Clarence W · Markham, TXBuilt 1957 · S/N 34669 N3969QRegistration Pending · Greeley, CORegistration pending, canceledBuilt 1974 · S/N 18502216 N3969YCayce Dick Lon Jr · Longview, TXS/N 21058469 N396BSpring Creek Financial Inc · Lewistown, MTBuilt 1992 · S/N EA-537 N396HRFussell Jerry Bernard · Nemo, SDBuilt 2016 · S/N T24002121 N396PMHansen Donald · Big Lake, MNBuilt 1963 · S/N D-7195 N396RPPelfrey Rosemarie · Choctaw, OKBuilt 2011 · S/N E-3960 N396SSHendrix Todd M · Bakersfield, CABuilt 2008 · S/N 1015 N396TCG/A Enterprise LLC · Elizabeth, COBuilt 1956 · S/N 32501 N397Ioannou Yiannakis C · Wilmington, NCBuilt 1976 · S/N P3370248 N3970GBack Country Flying Experience Inc · Kalispell, MTBuilt 1967 · S/N U206-0970 N39718Wood Allan W · Santa Fe, NMBuilt 1978 · S/N 28R-7803359 N3971DGreene Robert K · Athol, IDBuilt 1957 · S/N 34671 N3971YLimestone County Sheriff Dept · Athens, ALBuilt 1964 · S/N 21058471 N39724Huebscher Attila · Pittstown, NJBuilt 1978 · S/N 34-7870418 N3972GCounty Of Merced Sheriff'S Dept · Merced, CABuilt 1967 · S/N U206-0972 N3973DPatrick Arthur L · Rome City, INBuilt 1957 · S/N 34673 N3974GStaheli Lee E · Kiana, AKFirst renewal noticeS/N U206-0974 N3974XAngel Aviation Inc · Peoria, AZBuilt 1975 · S/N 34-7670011 N39759Shoaf Thomas P · Alamogordo, NMBuilt 1978 · S/N 34-7870419 N3976GBeauboeuf Andre F · Center Sandwich, NHBuilt 1967 · S/N U206-0976 N3977DEasom William J · Thousand Oaks, CABuilt 1947 · S/N 34677 N3979JMyers Melissa · Yukon, OKBuilt 1978 · S/N 34-7870346 N3979YMontana Adventures Holdings LLC · Rainbow City, ALS/N 21058479 N397AGMelmed Gavin · Dallas, TXBuilt 2026 · S/N 11493 N397AWPapa Tango Aviation LLC · Kalispell, MTBuilt 1980 · S/N TJ-207 N397DFolse Michael John · San Jose, CABuilt 1968 · S/N TC-1109 N397DDDelta Delta LLC · Washington, DCBuilt 2023 · S/N 9131 N397MSGregory Wm Broburg Ltd · Minneapolis, MNS/N 21061449 N397STRegistered aircraftBuilt 2006 · S/N 41706

Back to AD 2000-23-21