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.

N52735Patzoldt Quenton A · Pine City, MNBuilt 1974 · S/N 18262806 N52736Busick Clifford E · Stevenson Ranch, CABuilt 1974 · S/N 18262807 N52739Above All Aviation Inc · Santa Barbara, CABuilt 1974 · S/N 18262810 N5273DDrath Mark O · Reedsville, WIBuilt 1957 · S/N 50171 N5273EDaniels Ronald H · Delton, MIBuilt 1959 · S/N 50573 N5273FPsc Leasing LLC · Nokesville, VABuilt 2009 · S/N 18282193 N5273KColumbia Fire & Safety LLC · Wilmington, DEBuilt 2002 · S/N 18281162 N5273TFunk Michael W · Windham, NHBuilt 1982 · S/N R18201846 N52746Kravchenko Aleksandr · Everett, WAS/N 18262815 N52748Hall Howard S · Covington, GABuilt 1974 · S/N 18262816 N5274DSimonsen Deanne M · White Salmon, WABuilt 1958 · S/N 50172 N5274EFedermann Joe R · Anchorage, AKBuilt 1959 · S/N 50574 N5274SHap'S Air Inc · Ames, IABuilt 1980 · S/N R18201534 N5274YMba Sales LLC · Ridgefield, WABuilt 1980 · S/N 21064147 N52751Weinstein Mark H · Carrollton, GABuilt 1974 · S/N 18262819 N52753Omark Aviation LLC · Naples, FLBuilt 2002 · S/N 18281164 N52754Torgerson'S LLC · Ethridge, MTBuilt 1974 · S/N 18262822 N52757Brady Aviation Ltd Co · Friendswood, TXBuilt 2002 · S/N 18281165 N52758Luse David C · Newalla, OKBuilt 1974 · S/N 18262825 N5275DWorrell Sharyl L · Anchorage, AKBuilt 1958 · S/N 50173 N5275EPasiewicz Shannon M · Anchorage, AKBuilt 1959 · S/N 50575 N5275VViatrans LLC · Pryor, OKBuilt 1975 · S/N 21060890 N52761Reb Baron Aviation LLC · Riverdale, CAS/N 18262828 N52764Skylane LLC · Williamsburg, VABuilt 1974 · S/N 18262831 N52767Loudy William E · Rigby, IDBuilt 1974 · S/N 18262834 N5276AOstermeier Brigitte · MaunNon-citizen corporation, flight hours not reportedBuilt 1979 · S/N 21063341 N5276ESchmutz George L · Atascadero, CABuilt 1983 · S/N 18268306 N5276VSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1975 · S/N 21060891 N52775Pa-18 LLC · Hood River, ORBuilt 1974 · S/N 18262837 N5277JYr-Aircraft Leasing LLC · Bethel, AKBuilt 1984 · S/N 20700772 N5277PBennett Glenn D · Kingwood, TXBuilt 1977 · S/N 21061784 N5277VLechner Gary D · Woodstock, ILBuilt 1975 · S/N 21060892 N52781Mckendry Martin · Carmel Valley, CABuilt 1974 · S/N 18262840 N52783Valdes Alfonso · El Paso, TXBuilt 1974 · S/N 18262842 N52792Ball Richard W · Ridgefield, CTBuilt 1974 · S/N 18262848 N52795Key Lime Consultants LLC · Belleview, FLS/N 18262851 N52797Supinie Andy · Wichita, KSBuilt 1974 · S/N 18262852 N527BMMarc Inc · Bolton, MSS/N P2060035 N52808Thane Inc · Elkridge, MDBuilt 1974 · S/N 18262862 N52812Northern Air Inc · Bonners Ferry, IDBuilt 1974 · S/N 18262866 N5281DRocky Pointe Logistics LLC · Hayden, IDBuilt 1958 · S/N 50179 N5281VOne Vector LLC · Wolcott, COBuilt 1975 · S/N 21060896 N52821Big Bird Aerial Photography LLC · Astoria, ORBuilt 1974 · S/N 18262871 N52829Western Heights LLC · Boise, IDBuilt 1974 · S/N 18262879 N52836Payne Thomas E · Old Forge, NYBuilt 1974 · S/N 18262885 N5283NGibson Bruce S · Cayucos, CABuilt 1980 · S/N 18267617 N5284KSmith Nathan C · Kenai, AKBuilt 1975 · S/N 180-52598 N5284NMiller Kevin A · Littleton, COS/N 18267618 N5284TSinclair James Stanley · Douglas, GAS/N R18201848 N5284UCochrane Timothy A · Chippewa Lake, OHBuilt 1964 · S/N U206-0284

Back to AD 84-10-01 R1