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.

N91602Kreikemeier Michael L · Belgrade, MTBuilt 1969 · S/N 18259838 N91604Veeref LLC · Temecula, CAS/N 18259840 N91606Zoltak Aviation LLC · Perry, GABuilt 1969 · S/N 18259841 N91607Parreira Paul Jr · Dos Palos, CABuilt 1969 · S/N 18259842 N91614Hendrich Matthew G · Paso Robles, CABuilt 1969 · S/N 18259844 N9161CLatta Michael D · Auburn, WABuilt 1954 · S/N 31260 N9161GBowling Gary L · Elk City, IDBuilt 1971 · S/N 18260701 N91621Whitney Richard J · Mason City, ILBuilt 1969 · S/N 18259846 N91626Tmstar Services LLC · Lewes, DEBuilt 1969 · S/N 18259850 N9163GHayssen Arthur H · Sebastopol, CABuilt 1971 · S/N 18260703 N9164CMonmouth Aircraft Services Inc · Toms River, NJBuilt 1978 · S/N R18200433 N9164GZirjacks Winston L Jr · Gold River, CABuilt 1971 · S/N 18260704 N91651Cain Edward A · Pembroke, MABuilt 1969 · S/N 18259856 N91657Webster Max S · Dalton, PAS/N 18259858 N9165XShults Jerry G · Kingsland, TXBuilt 1961 · S/N 18253565 N91661James One Seventeen LLC · Fairview, OKBuilt 1969 · S/N 18259861 N91667Dennis Robert · Rosamond, CAS/N 18259863 N91670Sierrahotellima LLC · Farmingdale, MEBuilt 1969 · S/N 18259864 N91672Baldridge Steven J · Edmonds, WAS/N 18259865 N9167GKgrd Aviators LLC · Greenwood, SCBuilt 1971 · S/N 18260707 N9167XRichard I French · Eatonville, WABuilt 1961 · S/N 18253567 N91680Kay Scott Aviation Insurance Inc · Reno, NVBuilt 1969 · S/N 18259869 N9168GClark Byron · Olympia, WABuilt 1971 · S/N 18260708 N91690Walker Curtis N · Phoenix, AZBuilt 1969 · S/N 18259872 N91691Stumm Robert W · Cadott, WIBuilt 1969 · S/N 18259873 N91699Caughlan Cody P · Santa Cruz, CABuilt 1969 · S/N 18259875 N9169CVajdos Robert C Jr · Louise, TXBuilt 1955 · S/N 31268 N9169GDodson International Parts Inc · Rantoul, KSBuilt 1971 · S/N 18260709 N9169XAllen Air LLC · Fennville, MIBuilt 1961 · S/N 18253569 N916ACYr-Aircraft Leasing LLC · Bethel, AKBuilt 1979 · S/N 20700061 N916DFGasmire Charles · Frisco, TXBuilt 1975 · S/N 18264026 N916GGSutton Aircraft Salvage LLC · Palmer, AKBuilt 1959 · S/N 52236 N916WCBarr Air Patrol LLC · Mesquite, TXBuilt 1980 · S/N U20605677 N916WRPsl Surveys · Manassas, VAFirst renewal noticeS/N 18282262 N91705Gerbick Dean · Lena, ILBuilt 1969 · S/N 18259878 N91718Miklos Russ · Youngstown, OHBuilt 1969 · S/N 18259882 N9171CCartright Eugene · Pelham, NHBuilt 1978 · S/N R18200435 N9171MCarbon 182 LLC · Montgomery, TXBuilt 1976 · S/N 18264717 N9171TLangmuir Circulation LLC · Perkasie, PABuilt 1959 · S/N 50671 N91721Scott Dennis E · Wake Forest, NCBuilt 1969 · S/N 18259883 N91722Ken-Oh Transportation LLC · Porter, INBuilt 1969 · S/N 18259884 N91726Kcsi Aerial Patrol Inc · Bakersfield, CABuilt 1969 · S/N 18259886 N9172CBolinger Dean R · Bend, ORBuilt 1954 · S/N 31271 N9172MWebster Lyle H · Wichita, KSBuilt 1976 · S/N 18264718 N9172XRegistered aircraftBuilt 1961 · S/N 18253572 N91730Meints Larry W · Altahoma, CABuilt 1969 · S/N 18259887 N9173CBettendorf Nicholas L · Mchenry, ILBuilt 1978 · S/N R18200436 N9173KBoutin Steven · North Babylon, NYS/N 18051315 N91748Ad Venture Sales LLC · Wilmington, DEBuilt 1969 · S/N 18259890 N91749Skydive Northstar LLC · Mankato, MNBuilt 1969 · S/N 18259891

Back to AD 84-10-01 R1