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.

N4841NRegistration Pending · Columbus, OHRegistration pendingBuilt 1979 · S/N 18267411 N4841RBlack Gulch Aviation LLC · Polson, MTBuilt 1975 · S/N 18802360T N4842DTablerock Cattle Co LLC · Lacrosse, WABuilt 1958 · S/N 34942 N4842JTayrien Jacob A · Queen Creek, AZBuilt 1966 · S/N CE-123 N4842KKinetic Group LLC · Eagle, IDBuilt 1979 · S/N P21000343 N4842QBlack Gulch Aviation LLC · Polson, MTBuilt 1976 · S/N 18802578T N4842UMadsen Gerald H · Seattle, WAFirst renewal noticeBuilt 1964 · S/N 2050542 N4843CPayne Thomas E · Old Forge, NYBuilt 1975 · S/N 18502611 N4843RFriesenborg & Larson Custom Spraying Lc · Buffalo Center, IABuilt 1975 · S/N 18802362T N4844BPrevost Christopher D · Sonoma, CAS/N 35144 N4844DLewis Joseph W · Decatur, TXS/N 34944 N4844KMccoy Robert G Jr · Marshville, NCBuilt 1979 · S/N P21000344 N4844NTurbyfill Tony L · Vina, ALBuilt 1979 · S/N 18267414 N48458Peterson Timothy R · Monument, COBuilt 1971 · S/N D-9291 N4845CBloss Albert P · Seattle, WABuilt 1979 · S/N 21063642 N4845EEllis Jeffrey · Davis, ILBuilt 1979 · S/N 18503887 N4845MMedore Douglas A · Romoland, CABuilt 1959 · S/N 24569 N4845UKris Noone Air LLC · Wilmington, DES/N 205-0545 N4846DYoung Jason · Anchorage, AKBuilt 1958 · S/N 34946 N4847UTaylor Livingston · Watertown, MABuilt 1964 · S/N 205-0547 N4847VNutter Michael S · University Place, WABuilt 1968 · S/N 30102 N4848DThompson Kelly W · Portland, ORBuilt 1959 · S/N 52082 N48490Nikitas Harris P Jr · Fitchburg, MABuilt 1956 · S/N 24563 N4849JEast Side Mosquito Abatement District · Modesto, CABuilt 1981 · S/N 18803773T N4849QSouther Field Aviation Inc · Americus, GABuilt 1976 · S/N 18802585T N484CCWitke Ray · Menomonie, WIBuilt 2018 · S/N 33-0009 N484DAlman Inc · Fort Lauderdale, FLBuilt 1992 · S/N CE-1699 N484HPFly With Kay LLC · Fulshear, TXBuilt 1981 · S/N 34-8133199 N484JRC L Farwell Holdings III LLC · Brookline, NHBuilt 1966 · S/N CE-120 N484KCN484kc LLC · Salem, ORBuilt 2007 · S/N 2752 N484KWNunez-Fontes Fernando · Rio Rico, AZBuilt 1980 · S/N 21064066 N484LACirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11585 N484SWElsass Aviation LLC · Fayetteville, ARBuilt 1980 · S/N 414A0497 N484TManhattan Medical Consultants LLC · Mckinney, TXBuilt 2025 · S/N 11042 N485Obenchain David W · Simi Valley, CABuilt 1959 · S/N 50595 N4850JCardamone Rayner Mark Gibson · Manistique, MIBuilt 1966 · S/N D-8345 N4850URegistration Pending · Elsie, MIRegistration pendingS/N 205-0550 N4851JAbernathy Spraying Service Inc · Tipton, OKBuilt 1981 · S/N 18803774T N4852ESproul David Douglas Jr · Heath, TXBuilt 1979 · S/N 18503888 N4852JStoffel Christopher David · Colorado Springs, COS/N D-8349 N4853CIdaho Flying Service LLC · Kamiah, IDS/N U20603851 N4853DCrosgrove Shawn R · Riverton, UTBuilt 1958 · S/N 34953 N4853JNaca 130 LLC · Cameron Park, CABuilt 1966 · S/N D-8350 N4854RFisher Ag Service LLC · Cardington, OHBuilt 1975 · S/N 18802373T N4854URieser Donald E · Antioch, ILBuilt 1964 · S/N 205-0554 N4855CFoss James K · Anchorage, AKBuilt 1975 · S/N 18502623 N4855DRegistration Pending · Peachtree City, GARegistration pendingS/N 34955 N4855VGlide Slope Aviation Inc · Myakka City, FLFirst renewal noticeBuilt 1968 · S/N 30109 N4856JN4856j LLC · Boulder, COBuilt 1967 · S/N D-8536 N4857CGate Holdings LLC · Ketchum, IDBuilt 1979 · S/N 21063647

Back to AD 2000-23-21