Skip to content

Registered aircraft · 20,481

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N72106Dahl George Robert · Bethel, AKBuilt 1969 · S/N U206-1282 N7210NHansen Arthur R · Cheyenne, WYS/N 18263002 N72117Ott Steve G · Reedpoint, MTBuilt 1969 · S/N U206-1286 N7211NGallacci Jefry S · Mattawa, WAS/N 18263003 N7213NSouth Aero LLC · Albuquerque, NMBuilt 1979 · S/N 21063207 N7214NThompson Jared N · Hayden, IDS/N 18263005 N7215EPatton James Jay · Sequim, WAS/N 52215 N72160Mccauley Thomas I · Puyallup, WAS/N U206-1303 N7216EZeus Air Inc · Wilmington, DES/N 52216 N7217ERomo Daryl · Anchorage, AKBuilt 1959 · S/N 52217 N7218ERice Ross H · Moab, UTBuilt 1959 · S/N 52218 N72194Skydive Ky LLC · Cecilia, KYBuilt 1969 · S/N U206-1315 N721AEmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 1978 · S/N 18266259 N721KCVan Brunt Paul A · East Bethel, MNBuilt 1977 · S/N R18200090 N721NRUS Department Of The Interior · Boise, IDBuilt 1985 · S/N U20606902 N721SGAlaska Air Service LLC · Brookings, ORBuilt 1964 · S/N 206-0265 N721ZASky-Vu Flyers Inc · Fishers, INBuilt 2004 · S/N 18281439 N7220NNatural Selection Farms Inc · Sunnyside, WABuilt 1974 · S/N 18263011 N7221EMuller Farm And Ranch · Grenora, NDBuilt 1959 · S/N 52221 N7221SGardner Riley F · Hamilton, TXBuilt 1976 · S/N 18265083 N72222Jouppi Kenneth J · Ward Cove, AKBuilt 1969 · S/N U206-1329 N7222NN B Tweet & Sons · Nome, AKBuilt 1976 · S/N U20603568 N7223NLee Stephen J · Cadiz, KYS/N 18263014 N7224EHowenstein John G · Roseville, CABuilt 1959 · S/N 52224 N7224NCook Jon I · Cloudcroft, NMBuilt 1974 · S/N 18263015 N7226EKinnebrew John · Adkins, TXBuilt 1959 · S/N 52226 N72285Cave Creek Organics LLC · Flagstaff, AZBuilt 1969 · S/N U206-1351 N72288Roberts Matthew R · Idaho Falls, IDFirst renewal noticeBuilt 1969 · S/N U206-1353 N7229ECreighton Richard L · Cincinnati, OHBuilt 1959 · S/N 52229 N722BASunshine Airplanes LLC · Chandler, AZBuilt 1971 · S/N 18260915 N722BCNordberg Chad J · Moses Lake, WABuilt 1973 · S/N 18262051 N722BSAnstrand Charles J · Boise, IDBuilt 1959 · S/N 52252 N722CPFalcon 118 Denver LLC · Tiburon, CABuilt 1998 · S/N 18280090 N722DMU S Wire Manufacturers Inc · Redwood City, CABuilt 1998 · S/N 18280199 N722EELipham William H · Odessa, TXBuilt 1965 · S/N 18256238 N722ELBristow Bryan M · Albany, ORBuilt 1981 · S/N 21064332 N722JC722jc LLC · Tyler, TXBuilt 1968 · S/N 18259489 N722PDW O Zangger And Son Inc · North Loup, NEBuilt 1976 · S/N 21059833 N722RGTri Ag Supply Inc · Harvard, ILBuilt 1981 · S/N 18268099 N722RRAncira Autos LLC · San Antonio, TXBuilt 1979 · S/N 21063651 N722SJJackson Stephen L · Belvidere, ILBuilt 1976 · S/N U20603361 N722TMHenry John W · San Jose, CABuilt 1968 · S/N 18259512 N72306Usda Aphis Ppq · Edinburg, TXBuilt 1969 · S/N U206-1360 N72309Orion Works Ltd · Denali Park, AKBuilt 1969 · S/N U206-1362 N7230SMarsh John E · Washington, DCBuilt 1976 · S/N 18265084 N72313Alaskan Air Charter LLC · Anchorage, AKBuilt 1969 · S/N U206-1365 N7232ESitta Donald C · Farmington, NMBuilt 1959 · S/N 52232 N7232NT&A Farm LLC · Rifle, COBuilt 1974 · S/N 18263023 N72337Gilbert Daniel Keith · Kodiak, AKBuilt 1969 · S/N U206-1374 N72347Hone Landscape Company LLC · Carnation, WABuilt 1969 · S/N U206-1377

Back to AD 84-10-01 R1