Skip to content

Registered aircraft · 20,483

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.

N2137ZAnderson Kenneth L · Anchorage, AKBuilt 1963 · S/N 18051237 N2138SStamm Roy Peter · Woodstock, GABuilt 1975 · S/N 21061099 N21393Dinelli Aviation LLC · Milton, DES/N 18261607 N21395Faignant J Brian Jr · Anchorage, AKBuilt 1972 · S/N 18261608 N21396Greers Banner Air Of Bakersfield Inc · Bakersfield, CABuilt 1972 · S/N 18261609 N2139CWilson Todd B · Newnan, GABuilt 1953 · S/N 16124 N2139FCrow Brian M · Oakesdale, WABuilt 1965 · S/N U206-0339 N2139GSoarmates LLC · Missoula, MTBuilt 1958 · S/N 51439 N2139RShaw Gregory A · West Richland, WABuilt 1964 · S/N 18255339 N213BGUpstate Flyers LLC · Woodruff, SCBuilt 1972 · S/N 18261580 N213CMBollingberg Kurt O · Cathay, NDBuilt 1997 · S/N 18280046 N213GCEastern Stearman Inc Trustee · Leesburg, VABuilt 1978 · S/N 21062368 N213GGShortcut LLC · Kihei, HIBuilt 2002 · S/N 18281130 N213LPT31 Aviation LLC · Dallas, TXBuilt 2004 · S/N 18281312 N213SMArrowhawk Imaging LLC · Morgantown, WVBuilt 2003 · S/N 20608206 N21401Sterling Steven G · Richland, WABuilt 1972 · S/N 18261612 N21402Hester James Timothy · Fayetteville, GABuilt 1972 · S/N 18261613 N21404Usglap · Fort Morgan, COBuilt 1972 · S/N 18261615 N21405Brushwood John W · Coshocton, OHBuilt 1972 · S/N 18261616 N2140CMilton William H · Amsterdam, NYS/N 16125 N2140GBoger Malcolm L · Dickens, TXBuilt 1958 · S/N 51440 N21413Botwinick Jeffrey Richard Patrick · Syracuse, NYBuilt 2003 · S/N 18281273 N21414Flyboys Flying Club LLC · Pawleys Island, SCBuilt 1972 · S/N 18261624 N21416Campbell David Lloyd · Fredericksburg, TXBuilt 1972 · S/N 18261626 N2141DFoturis Inc · Kingston, PABuilt 2003 · S/N 18281297 N2141FHill Henry M · Sleetmute, AKBuilt 1965 · S/N U206-0341 N2141GFreiheit Larry · Clinton, MOBuilt 1958 · S/N 51441 N21421Paul Janet K · Beaver Island, MIBuilt 1972 · S/N 18261630 N2142CSteinsvik Magne · Seattle, WABuilt 1953 · S/N 16127 N2143SBaiocchi Ken P · San Jose, CABuilt 1975 · S/N 21061104 N21445Woody Dwain F Trustee · Lubbock, TXBuilt 1972 · S/N 18261632 N2144RButterfield Stephen · Nampa, IDS/N 18255344 N2144VAnson Air LLC · Sugar Land, TXBuilt 2003 · S/N 18281276 N2144ZBeerle Brion J · Anchorage, AKBuilt 1963 · S/N 18051244 N21450Brant Gary E · Salisbury, PABuilt 1972 · S/N 18261637 N21453Super D Electric Inc · Coeur D Alene, IDBuilt 1972 · S/N 18261640 N21454Textron Aviation Inc · Wichita, KSBuilt 2003 · S/N 18281228 N21457Registration Pending · Deland, FLRegistration pendingBuilt 1973 · S/N 18261642 N2145GGraham William F III · North Wilkesboro, NCBuilt 1958 · S/N 51445 N2145SHenry James · Bonita, CABuilt 1975 · S/N 21061106 N21461Acme Aviation Inc · Lake Charles, LABuilt 1972 · S/N 18261645 N21462Fly Man LLC · Waxhaw, NCBuilt 1972 · S/N 18261646 N21465Clary Kenneth W Sr · Huntsville, TXS/N 18261648 N2146AZhukov Igor · Live Oak, FLBuilt 2003 · S/N 18281265 N21472Registered aircraftBuilt 1972 · S/N 18261652 N21474Alexander David L · North Pole, AKBuilt 1972 · S/N 18261654 N21475Austin Police Dept · Pflugerville, TXBuilt 1972 · S/N 18261655 N21477Frizzell Richard W Jr · Blacksburg, VABuilt 1972 · S/N 18261657 N2147CBas Part Sales LLC · Greeley, COBuilt 1954 · S/N 16132 N21487Millennial Flight LLC · Kalispell, MTS/N 18261663

Back to AD 84-10-01 R1