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.

N18MJFleeman Julie · Laguna Niguel, CABuilt 1978 · S/N E-1250 N18MRMorey Airplane Co Inc · Middleton, WIBuilt 1978 · S/N 340A0557 N18MTBaker John Bennett · Tahoka, TXS/N 4237 N18NFR D Aviation LLC · Phoenixville, PABuilt 1967 · S/N 21058903 N18NSGilberto Alfonso · Washington, NCBuilt 1978 · S/N R1723066 N18PBStogner Terry W · Lamesa, TXBuilt 1967 · S/N 18258216 N18PSSelect Airparts · Weyers Cave, VABuilt 1957 · S/N BG-327 N18PWPhenix LLC · Dayton, WABuilt 1963 · S/N 21058192 N18PYHeavenly Flight LLC · Cumming, GABuilt 2022 · S/N 8856 N18RBDuval Kenneth M · Richardson, TXBuilt 1973 · S/N CE-461 N18RKJacksonville Twin Comanche LLC · Kalispell, MTFirst renewal noticeBuilt 1979 · S/N 34-7970151 N18SAWatkins Aviation LLC · Kenton, OHBuilt 2005 · S/N 1401 N18SBTroy Motz Construction Inc · Lincolnton, NCBuilt 1978 · S/N 18266338 N18SGBennett Jeannette DBA · Joiner, ARFirst renewal noticeBuilt 1975 · S/N 310R0560 N18SYWingz Wi LLC · Milwaukee, WIBuilt 2024 · S/N 10038 N18TBCarlson Herb Trustee · Dana Point, CABuilt 1981 · S/N 18267978 N18TKMcpherson Kathrynne Alexine Trustee · Twin Falls, IDBuilt 1961 · S/N 18253360 N18TLCarey Nicolas J · Rosamond, CAS/N 18259225 N18TPPotter Todd J · Warrens, WIBuilt 1979 · S/N 34-7970431 N18TUCheck Seven LLC · Champaign, ILBuilt 1967 · S/N D-8450 N18VGBullet Aviation LLC · Missoula, MTBuilt 1999 · S/N E-3255 N18VJAssurance Data Inc · Indiana, PABuilt 1984 · S/N TJ-445 N18VRVentura Air LLC · Wilmington, DEBuilt 1996 · S/N TH-1771 N18VUVincennes University · Vincennes, INBuilt 1977 · S/N 310R0928 N18WDSeferiadis David · North Wales, PABuilt 2017 · S/N 4513 N18WGBest Way Flights LLC · Magnolia, TXBuilt 2015 · S/N 4250 N18WLMiller Christopher M · Centreville, VABuilt 1981 · S/N 18053178 N18WPPacker William M · Orchard Lake, MIBuilt 1966 · S/N D-8125 N18WWFourth Sister LLC · Wilmington, DEBuilt 1994 · S/N E-2860 N18XBecker James · Crystal Lake, ILBuilt 1978 · S/N E-1353 N18ZPPierce Lestley R · Henderson, NVS/N 18263562 N1900XAtkinson Ron D · Myrtle Creek, ORBuilt 1965 · S/N 18256000 N1901LBerry Darrel · Camden, TNBuilt 1976 · S/N TH-754 N1901XBuehler Jon R Trustee · Scott City, KSBuilt 1965 · S/N 18256001 N19022Delta Lima Foxtrot LLC · Kalispell, MTBuilt 1980 · S/N 18053176 N1902XKelly Jerome · Babbitt, MNBuilt 1965 · S/N 18256002 N1903LN1903l LLC · Jacksonville, FLBuilt 1976 · S/N D-9900 N1903XAivcon Inc · Charlevoix, MIBuilt 1965 · S/N 18256003 N1904FRoberts Walter A · Emery, SDBuilt 1966 · S/N 18257699 N1904LJones William D · Argyle, TXBuilt 1963 · S/N D-7174 N1905B605 Aviation LLC · Aberdeen, SDBuilt 1978 · S/N 414A0214 N1905ERusso Louis A Jr · Houston, TXBuilt 1979 · S/N 340A0664 N1905ULeichtfuss Brad · Lake Havasu City, AZBuilt 1973 · S/N U20602275 N1906FP206-1 LLC · Carrollton, GABuilt 1964 · S/N P206-0001 N1906XLawless Mark · Des Moines, IABuilt 1965 · S/N 18256006 N1908GAir Z Flying Service Inc · Richmond Heights, OHBuilt 1974 · S/N 310R0055 N1908MAirtrader LLC · Hornersville, MOBuilt 1975 · S/N 18264473 N1909FMarshal Group LLC · Lucedale, MSBuilt 1964 · S/N P17257189 N1909L52 Foxtrot Aviation LLC · Billings, MTBuilt 1976 · S/N D-9901 N1909XBowie Dana M · England, ARBuilt 1965 · S/N 18256009

Back to AD 2000-23-21