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.

N355TBravo Busters LLC · Kalispell, MTBuilt 2008 · S/N 3311 N355TAIsland Amphibs LLC · Fort Lauderdale, FLFirst renewal noticeBuilt 1976 · S/N U20603446 N355TFCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11594 N355TGHigh & Fast LLC · Batesville, ARBuilt 2006 · S/N 2158 N355WBWhite River Aviation LLC · Midway, ARBuilt 1966 · S/N TE-287 N355WTSerious Business LLC · Gregory, SDBuilt 2015 · S/N 4167 N355XTressler Kevin L · Bethel, AKBuilt 1976 · S/N 6179C N355YPlussa Mark George · Clermont, FLBuilt 1980 · S/N 21064137 N355ZRoeder Richard E · Emmett, IDBuilt 1960 · S/N CD-387 N356Endless Sky LLC · Temple, GABuilt 2021 · S/N 2308 N3560FAdams Chris · Braselton, GABuilt 1966 · S/N 18257560 N3560MBeyond Grateful LLC · Frisco, COBuilt 1978 · S/N 28R-7803177 N3560UMcmaster John F · Wichita, KSBuilt 1963 · S/N 18254960 N3560YTriple J&M Flying LLC · Guymon, OKBuilt 1962 · S/N 18254460 N3561QSales Joe H · Seminole, TXBuilt 1969 · S/N 188-0511 N3561XAereotronics Inc · Wilmington, DEBuilt 1980 · S/N 34-8070073 N3561YDk Futures LLC · Reno, NVBuilt 1962 · S/N 18254461 N3562FHexd Medical · Rexburg, IDBuilt 1966 · S/N 18257562 N3562UPrairie Aviation Of Hamilton Inc · Corvallis, MTBuilt 1963 · S/N 18254962 N35636Carreno Miriam · Portland, ORBuilt 1979 · S/N 28R-8031036 N3563FParker Layne T · Gustavus, AKBuilt 1966 · S/N 18257563 N3563UWest Robert M · Lake Oswego, ORBuilt 1963 · S/N 18254963 N3563YHegge Luke · Pine City, MNBuilt 1962 · S/N 18254463 N3564USkylane LLC · Luling, LABuilt 1963 · S/N 18254964 N3565FKlosowski Mark Kevin · Lisbon, NYBuilt 1966 · S/N 18257565 N3565JKendrick Ross Mitchell · Sycamore, GABuilt 1980 · S/N T18803651T N3565YRegistration Pending · Conrad, MTRegistration pendingS/N 18254465 N3566WGriffin Aviation LLC · Minneapolis, MNBuilt 1999 · S/N TH-1930 N3566YTocco Paul J · Crescent City, FLBuilt 1962 · S/N 18254466 N35677C3 Indutries LLC · Bakersfield, CABuilt 1973 · S/N 21060007 N3567FPbj Skylane LLC · Sparks, NVBuilt 1966 · S/N 18257567 N3568UCsi Aviation LLC · Wilmington, DEBuilt 1963 · S/N 18254968 N3568YAerial Adventures Demo Inc · Hopewell, VABuilt 1962 · S/N 18254468 N3569QTerry Woodard Enterprises Inc · Beaumont, TXBuilt 1977 · S/N 28R-7703115 N3569UHelicopter Of Columbia LLC · Columbia, SCS/N 18254969 N3569YSage Michael · Opelika, ALBuilt 1962 · S/N 18254469 N356CAWest Road LLC · Whiting, VTS/N 42502 N356DK1 Grand Rotorsport LLC · Princeton, WVBuilt 2018 · S/N 1674 N356JPKukuruznik LLC · Weston, MABuilt 2006 · S/N 1604 N356JTHorizon Aviation LLC · Mobile, ALBuilt 1960 · S/N 18253096 N356LEFly Pharmd LLC · Valdosta, GABuilt 2007 · S/N 2652 N356PLBongiorni Robert W · Burgettstown, PABuilt 1978 · S/N R1722987 N356RKMec2 Aviation LLC · Catonsville, MDBuilt 2012 · S/N 3857 N356SCHogge Steven D Trustee · Colfax, CABuilt 2011 · S/N 0256 N356TTMercator Aviation LLC · Orlando, FLBuilt 2020 · S/N 4971 N356WBMwm Interests Inc · The Woodlands, TXBuilt 2009 · S/N 261 N3570UDoyle Neil R · North Pole, AKBuilt 1963 · S/N 18254970 N3571YIllinois Valley Parachute Club · Carlock, ILBuilt 1962 · S/N 18254471 N3572ADavis Robert D · Independence, ORBuilt 1969 · S/N TC-1306 N3572UFrappollo Paul M · Berryville, VABuilt 1963 · S/N 18254972

Back to AD 2000-23-21