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.

N226SCJohnson Lansworth P · Jackson, WYBuilt 1984 · S/N EA-406 N226SRDairyaire LLC · Brookfield, WIBuilt 2023 · S/N 9179 N226TWBb Aviation LLC · Louisville, KYBuilt 2019 · S/N 4837 N226TXGriffin Christopher W · Blowing Rock, NCBuilt 2009 · S/N 3390 N226XYTar Aviation LLC · Akron, IABuilt 2003 · S/N 0486 N2270FAlbair William R · Hampden, MEBuilt 1967 · S/N 310L-0070 N2270LBas Part Sales LLC · Greeley, COBuilt 1976 · S/N E-922 N2271LBurchinal Skyler · Brookston, TXS/N TJ-71 N2271RLowe Vance E · Oakland Park, FLBuilt 1969 · S/N T210-0421 N2271XSantaska Inc · Palmer, AKBuilt 1965 · S/N 337-0171 N2272FGear Down Hangar LLC · Phoenix, AZBuilt 1967 · S/N 310L-0072 N2272GThompson Todd M · Manito, ILBuilt 1958 · S/N 51572 N2272HSurric Aviation LLC · Barrington, ILBuilt 2016 · S/N 2316 N2272LBaum Jeffrey · Sheridan, WYBuilt 1976 · S/N D-9944 N2272RBerntsen Kurt · Upland, CABuilt 1969 · S/N T210-0422 N2272XSouthern Seaplane Inc · Belle Chasse, LABuilt 1970 · S/N U206-01556 N2273CCollins John J · Manitowoc, WIBuilt 1953 · S/N 30573 N2273LLtt Flights LLC · Clinton, MOFirst renewal noticeBuilt 1976 · S/N E-925 N2273XAll Florida Recovery Corp · Palm Coast, FLS/N 337-0173 N2274FElliott Areospace LLC · Kalispell, MTBuilt 1967 · S/N 310L-0074 N2274KSantee Cooper Aviation Inc · Saint Matthews, SCBuilt 1978 · S/N 18266454 N2274XDutko Adam M · Elyria, OHBuilt 1965 · S/N 337-0174 N2275CCrusader Medical Consulting LLC · Boonville, INBuilt 1982 · S/N T30300085 N2275KSutton Aircraft Salvage LLC · Palmer, AKS/N 51163 N2275LN2275l LLC · Ball Ground, GABuilt 1976 · S/N D-9945 N2276CLeading Edge Consulting LLC · Mitchell, SDBuilt 1976 · S/N CE672 N2276GRegistration Pending · Salt Lake City, UTRegistration pendingBuilt 1958 · S/N 51576 N2276MMuddy River Capital LLC · Glendive, MTBuilt 1977 · S/N 28R-7803119 N2277CC4 Holdings Group LLC · Odessa, FLBuilt 2026 · S/N 11434 N2277FEagle Mission LLC · Keystone Heights, FLBuilt 1956 · S/N 35352 N2277QComanche Aviation LLC · Chanute, KSBuilt 1977 · S/N 28R-7703060 N2277YSheffield Richard Lee · Los Alamos, NMBuilt 1972 · S/N 18261225 N22796Mahanor Michael F · Eaton, NHS/N 23471 N2279GParker Robert M · Hurst, TXBuilt 1958 · S/N 51579 N2279RLehmann Albert F II · Simpsonville, SCBuilt 1969 · S/N T210-0429 N2279UChristenberry Paul O · Fayette, ALBuilt 1970 · S/N 18800659 N2279XSander Farms Inc · Wilmington, DEBuilt 1965 · S/N 337-0179 N227ALGarbar Organization LLC · Duncan, SCBuilt 1975 · S/N 34-7670028 N227BDBlack Dog Aviation LLC · Avon, MNBuilt 2008 · S/N 3134 N227BRSchoo Michael J Trustee · Ridgway, COBuilt 1977 · S/N TK-31 N227BWLines Merrill Alan · Mesa, AZBuilt 2007 · S/N 1770 N227BYAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1970 · S/N TC-1347 N227CELynco Electric Co Inc · Las Cruces, NMBuilt 2023 · S/N 9618 N227CLCirrus Sr22t 2180 Inc Trustee · Wilmington, DEBuilt 2020 · S/N 2180 N227CMMmkb Inc · Wilmington, DEBuilt 1976 · S/N 18264533 N227DKirkland Daniel · Kingman, AZBuilt 1976 · S/N 21061540 N227DHFirst Sierra Insurance Services LLC · Fresno, CABuilt 2023 · S/N 9308 N227DZAd Holdings Group Inc · Wilmington, DEBuilt 2008 · S/N 3288 N227ESHkr Aero LLC · Chattanooga, TNBuilt 2023 · S/N 9201 N227FDSpettro Air LLC · Monroe, LABuilt 2023 · S/N 9113

Back to AD 2000-23-21