Skip to content

Registered aircraft · 109

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

N109UPlane Fun Inc Tr Trustee · Snellville, GAS/N VAC-152-80 N118WWWrigley Kevin J · Lexington, SCBuilt 1979 · S/N VAC-131-79 N2150SN2150s LLC · Charlotte, NCBuilt 1962 · S/N SP43 N215WMDoyle James M · Columbia, CAS/N VAC-123-79 N312BWGiacinto Lucci A Jr · Nashville, MIBuilt 1962 · S/N SP-44 N3150WRegistration Pending · Olympia, WARegistration pendingBuilt 1979 · S/N VAC-126-79 N4602VHearne Jerad · Madison, INS/N VAC76-77 N4603VLazy Ta Legend Aircraft LLC · Wilmington, DEBuilt 1977 · S/N VAC77-77 N4614VSwan Christopher L · Stillwater, OKBuilt 1977 · S/N VAC-89-78 N4617VSale Reported · Colorado Springs, COSale reportedS/N VAC-82-77 N4618VSeymour James H · Medina, OHBuilt 1977 · S/N VAC-83-77 N4619VSears Wes L · Tacoma, WABuilt 1977 · S/N VAC-84-77 N4630VFluhrer Norman P · Mendocino, CABuilt 1977 · S/N VAC-86-77 N4631VPoklar Janeen A · Mount Orab, OHBuilt 1977 · S/N VAC-87-77 N4632VMathews Steven · New Braunfels, TXS/N VAC-88-77 N4633VDelhotal Raymond K · West Brooklyn, ILBuilt 1977 · S/N VAC-90-78 N4637VChristian Swann & Associates Inc · Peachtree City, GABuilt 1977 · S/N VAC-92-78 N4638VRegistration Pending · Olympia, WARegistration pendingBuilt 1978 · S/N VAC-93-78 N4639VRunway 7 LLC · Lewes, DEBuilt 1978 · S/N VAC-94-78 N4640VHbhis LLC · Gnadenhutten, OHBuilt 1978 · S/N VAC-95-78 N4642VBolster William L · Joshua Tree, CABuilt 1978 · S/N VAC-96-78 N4644VHendricks Trenton Q · Bow, WABuilt 1978 · S/N VAC-98-78 N4646VBaran Stephen · Littlestown, PABuilt 1978 · S/N VAC-100-78 N5062VLeiby John S · Frostproof, FLBuilt 1974 · S/N VAC-50 N5063VLatham David C · Weld, MEBuilt 1975 · S/N VAC-51 N5064VSenita Kent · Dublin, OHBuilt 1975 · S/N VAC52 N5066VAction Center LLC · Morgan, UTBuilt 1975 · S/N VAC5476 N5067VKampert Keith Wayne Jr · Ninety Six, SCS/N VAC55-76 N5068VBarclay Alexander · Oshkosh, WIBuilt 1976 · S/N VAC 56-76 N5069VDieter Damian D · South Bend, INBuilt 1976 · S/N VAC-58-76 N5070VRiney Nicholas K · Prescott, AZBuilt 1976 · S/N VAC59-76 N5072VPolski Randy B · Baltimore, MDBuilt 1976 · S/N VAC-61-76 N5073VSeaton Brad S · Cache, OKBuilt 1976 · S/N VAC-62-76 N5075VSanders Jodie D · Fort Worth, TXS/N VAC-64-76 N5077VAdams Ron · Lovell, WYBuilt 1977 · S/N VAC-66-77 N5078VPapich William · Boston, NYS/N VAC-67-77 N5080VGentry Roy D · Mckinney, TXS/N VAC-69-77 N5081VWalker Gregory S · Gypsum, COBuilt 1977 · S/N VAC-70-77 N5082VMorton John W · El Segundo, CABuilt 1977 · S/N VAC-71-77 N5083VBarth Charles L · Pekin, ILBuilt 1977 · S/N VAC72-77 N5085VStumpf Douglas D · Aledo, TXBuilt 1977 · S/N VAC74-77 N5086VStreet Thomas G · Kingwood, TXS/N VAC75-77 N5105VOrr Samuel L · Cleveland, GABuilt 1958 · S/N FP-5 N5107VEckert Robert E · Edgewood, TXBuilt 1959 · S/N FP-7 N5108VDavis John K · Texarkana, ARBuilt 1959 · S/N FP-8 N5112VMertz Harry Z · Castle Rock, COBuilt 1961 · S/N SP-12 N5115VGruber Thomas · Seattle, WABuilt 1961 · S/N SP-15 N5116VWilliams Harry D III · Frostproof, FLS/N SP-16 N5123VAustin Jeffrey L Trustee · Salem, ORBuilt 1961 · S/N SP-19 N5124VAuiler Casey M · San Diego, CABuilt 1961 · S/N SP-20

Back to AD 80-02-08