Registered aircraft · 26,232

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:94-05-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') 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:94-05-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
  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:94-05-05-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
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.

N6214KHamptonville Aviation LLC · Hamptonville, NCBuilt 1975 · S/N 15077590 N6214SRex Douglas A · Marion, INBuilt 1967 · S/N 15067014 N62158Hoffman Ross M · West Point, GABuilt 1999 · S/N 038 N6215EReinders Gary J · Orange City, IABuilt 1958 · S/N 46315 N6215GSkagit Airport Eaa Chapter 818 · Shoreline, WAS/N 15071715 N6215SSmith Clifford W III · Exeter, CABuilt 1967 · S/N 15067015 N6216EPratt Joseph O · Wasilla, AKBuilt 1958 · S/N 46316 N6216STms Holdings LLC · Neenah, WIBuilt 1967 · S/N 15067016 N6217ESchiffel Peter W · Pequannock, NJBuilt 1958 · S/N 46317 N6217KIoannou Yiannakis C · Wilmington, NCBuilt 1975 · S/N 15077593 N6217RCampbell J R Jr · Bell, FLBuilt 1965 · S/N 15061517 N6217SKent J'Amy L · Chewelah, WAS/N 15067017 N6217TTaylor Nathan E · Spanishburg, WVS/N 15060917 N6218EZephyrhills Flying Club Inc · Tampa, FLBuilt 1958 · S/N 46318 N6218GGoatley Valerie M · Springfield, KYBuilt 1961 · S/N 17248655 N6218RAnnala John H · Dacula, GAS/N 15061518 N6219EOaks Randall K · Oxnard, CABuilt 1958 · S/N 46319 N6219KIrwin Michael C · North Fort Myers, FLBuilt 1975 · S/N 15077594 N6219RRegistered aircraftBuilt 1965 · S/N 15061519 N6219TCode4 Ventures Inc DBA · Waynesboro, VABuilt 1964 · S/N 15060919 N621APEast Moriches Aerial Ads Ltd · Ridge, NYBuilt 1971 · S/N 15073078 N621BKMy170b LLC · Everett, WAS/N 20819 N621MAAnderson Keith R · Norwood, MABuilt 1964 · S/N 15060905 N621MRElliott Michael R · Friendswood, TXBuilt 1972 · S/N 15073969 N621WHerzog Daniel L · Clinton, MIS/N 17248576 N6220EStoudt Kristen D · Derby, KSBuilt 1958 · S/N 46320 N6220GDuncan Paul J · Bartlett, TNBuilt 1970 · S/N 15071720 N6220KKasden Louis Jr · San Diego, CABuilt 1975 · S/N 15077595 N6220TStorey Erik A · Fillmore, CABuilt 1964 · S/N 15060920 N6221EAllgeier David G Jr · Taylorsville, KYBuilt 1958 · S/N 46321 N6221KWilson Steven J · Elkton, KYS/N 15077596 N6222EAlexander Tom · Alamogordo, NMBuilt 1959 · S/N 46322 N6222GCosgrove Coleman · Juneau, AKBuilt 1970 · S/N 15071722 N6222RBarge And Associates Inc · Houston, TXBuilt 1965 · S/N 15061522 N6223GGulasy Teresa L · Tulsa, OKBuilt 1970 · S/N 15071723 N6223RBroadwell Eric · Woodstock, GABuilt 1965 · S/N 15061523 N6223SKlingele Beth A · Wapato, WABuilt 1967 · S/N 15067023 N6225TMohnacky Robert A · Roscoe, ILBuilt 1964 · S/N 15060925 N6226KBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 1975 · S/N 15077599 N6226RHamman Baron L · Dallas, TXS/N 15061526 N6227KBuchman Jeffery · Bushnell, FLBuilt 1975 · S/N 15077600 N6228HVan Winkle Randy M · Van Buren, MOBuilt 1946 · S/N 19404 N6228RMangham Charles H · Mineral Wells, TXBuilt 1965 · S/N 15061528 N6228SYoder Edwin A Jr · Concord, GAS/N 15067028 N62299Blanton Robin Anthony · Vero Beach, FLBuilt 1950 · S/N 15638 N622EPGalletti Joseph N · Englewood, OHBuilt 2019 · S/N 1294 N622MRJorgensn Brian K · Sandpoint, IDBuilt 2005 · S/N AL-1016 N6230Cavanaugh Paul R · Plantsville, CTS/N 15071630 N6230EDean Matthew · Pine Grove, CAS/N 46330 N6230SMelnyk Oleg · Willoughby Hills, OHBuilt 1967 · S/N 15067030

Back to AD 94-05-05 R1