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.

N221VLLumen Air Holdings LLC · Clayton, MOBuilt 2026 · S/N 11405 N221WBOtter Rock Aero LLC · Newport, ORBuilt 2005 · S/N 41091 N221WSChaz LLC · Wilmington, DEBuilt 1976 · S/N CE-642 N22202Gifford Gregory L · Naples, FLBuilt 1972 · S/N 21059717 N2220NDushek Matthew S · West Hartford, CTBuilt 2000 · S/N 29-0228 N2220SSb Meridian LLC · Heber, CABuilt 1976 · S/N 21061165 N2220ZMoore Norman H · Weston, CTBuilt 1979 · S/N 28R-7931168 N2221Conley James Andrew · Merced, CABuilt 1960 · S/N 52538 N2221CCts Aviation Inc · Galesburg, MIBuilt 1953 · S/N 30521 N2221ZFielding David J · Scarborough, MEBuilt 1962 · S/N 1850319 N2222GCaswell Matthew N · Lubbock, TXBuilt 1958 · S/N 51522 N2222SFlyfoxco LLC · Dover, DEBuilt 2023 · S/N 9579 N2222XOrtiz Stewart Flynn · San Diego, CAS/N 337-0122 N22232Engeseth James Jr · Parker, COBuilt 1972 · S/N 21059730 N2223CElston Josh A · Sterling, AKBuilt 1953 · S/N 30523 N2223GS & M Partnership · Jasper, TXBuilt 1958 · S/N 51523 N2223TC & R Leasing LLC · Fairbanks, AKBuilt 1968 · S/N 185-1375 N2223ZKliewer Gary D · Fort Morgan, COBuilt 1979 · S/N 28R-7931170 N2224FE C Nelson Inc · Rio Oso, CABuilt 2000 · S/N 30-0051 N2224XRegistered aircraftBuilt 1965 · S/N 337-0124 N2224ZSexhus Sanford C · Southlake, TXBuilt 1979 · S/N 28R-7931171 N2225Ica Aviation LLC · Alexandria, VABuilt 2018 · S/N 4614 N2226LSlyngstad Todd · San Jose, CABuilt 1999 · S/N EA-640 N2226RChampion Crane Service Inc · Des Moines, IABuilt 1968 · S/N T210-0376 N2226SE S P Aviation LLC · Wilmington, DEBuilt 1976 · S/N 21061171 N2227WAb Christenson Holdings LLC · Bluffdale, UTBuilt 1979 · S/N 34-7970171 N2228DAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2000 · S/N 29-0246 N2228GHalo Halo LLC · Milwaukie, ORS/N 51528 N2228KSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 29-0269 N2228SHannaford Edward M · Roseville, MIBuilt 1976 · S/N 21061173 N2228UPeak Leasing LLC · Anchorage, AKBuilt 1979 · S/N 34-7970156 N2229CYleski LLC · Bozeman, MTBuilt 1953 · S/N 30529 N2229FMulligan Aviation LLC · Janesville, WIBuilt 2000 · S/N 29-0235 N2229SKey Lime Consultants LLC · Wilmington, DEBuilt 1976 · S/N 21061174 N2229XByers Gary F · Wasilla, AKBuilt 1969 · S/N 185-1509 N222ABStanderfer William E · Fort Collins, COBuilt 1973 · S/N TC-1527 N222ACMti Holdings Inc · Birmingham, ALBuilt 1977 · S/N E-1125 N222AHN222ah LLC · Key Largo, FLBuilt 2024 · S/N 10382 N222AKChambers Samuel S · Salmon, IDBuilt 1953 · S/N 30097 N222ALBca Aviation LLC · Pataskala, OHBuilt 2022 · S/N 8520 N222ASBenham Properties LLC · Sullivan, INBuilt 1968 · S/N TE-526 N222ATSierra 1 Tech Inc · Blue Jay, CABuilt 1968 · S/N 21059098 N222AVCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 1981 · S/N 34-8233006 N222AWJust Planes Inc · Hobbs, NMFirst renewal noticeBuilt 1969 · S/N 310P-0106 N222AXGraven Timothy G · Foristell, MOBuilt 1970 · S/N 414-0078 N222BANimbus Aviation LLC · Bellevue, WABuilt 2011 · S/N 0263 N222BGBeaumont David Matthew · Orcutt, CABuilt 2004 · S/N 1095 N222BJFlight Smith LLC · Orem, UTBuilt 1972 · S/N 414-0264 N222BTBt4 Holdings LLC · The Villages, FLBuilt 2018 · S/N 4726 N222BUDarrowby LLC · Medina, MNBuilt 2026 · S/N 11318

Back to AD 2000-23-21