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.

N730LCJones Christopher N · Edgewood, WABuilt 1979 · S/N 18267417 N730WMDennings Greg B · New Bremen, OHBuilt 1998 · S/N 18280361 N73100Alaska Air Taxi LLC · Anchorage, AKBuilt 1979 · S/N 20700559 N7310QDye Development LLC · Salem, OHBuilt 1972 · S/N 18260950 N73118Hudson Donald L Jr · Sellersburg, INBuilt 1975 · S/N 18264122 N7311SDayton Pilots Club Inc · Germantown, OHBuilt 1981 · S/N R18201703 N73123Lake Clark Air Inc · Port Alsworth, AKBuilt 1979 · S/N 20700561 N7312NOber John · Candor, NYS/N 18263097 N7312QRegistration Pending · Wilmington, DERegistration pendingBuilt 1972 · S/N 18260952 N7312SCuneo Timothy Angelo · Twin Falls, IDBuilt 1976 · S/N 18265104 N7312WRegistered aircraftBuilt 1977 · S/N R18200053 N7312XFellows Thomas C · Prescott, AZBuilt 1977 · S/N R18200071 N7313QWoodall Dan · Raleigh, NCFirst renewal noticeBuilt 1972 · S/N 18260953 N7313SRogers Matthew H · South Berwick, MEBuilt 1976 · S/N 18265105 N7315QNotman Steven J · Maunaloa, HIBuilt 1972 · S/N 18260955 N7316NHayes Charles David · North Pole, AKBuilt 1974 · S/N 18263100 N7316QAirborne LLC · Wilmington, DEBuilt 1972 · S/N 18260956 N7317SGoodman Jack A · Memphis, TNBuilt 1976 · S/N 18265109 N7317XMoore Samuel B · Tucson, AZS/N R18200073 N73182Savannah Airplanes Venture LLC · Myrtle Beach, SCBuilt 1973 · S/N 18261434 N7318SStahl K Joseph · Gainesville, TXBuilt 1976 · S/N 18265110 N7319QBassett Robert C · Gypsum, COBuilt 1972 · S/N 18260959 N7319TAlberta Aviation LLC · Wyoming, MIBuilt 1977 · S/N R18200028 N7319XHays Software Development LLC · Timnath, COBuilt 1977 · S/N R18200075 N731AALandis Lloyd B · Ardmore, OKBuilt 1970 · S/N 182-60331 N731CLNby Productions · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282256 N731MCFalk Arthur J · Southport, NCS/N 18265598 N731MJLake Chelan Helicopters LLC · Manson, WABuilt 1974 · S/N U20602362 N731RLTrevor Liou · Brush Prairie, WABuilt 1965 · S/N 18256519 N7320GDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1977 · S/N U20603763 N7320UYr-Aircraft Leasing LLC · Bethel, AKBuilt 1977 · S/N 20700397 N73211Tc International Inc · Whittier, CABuilt 1978 · S/N 182-66301 N73217Ryan Air Inc · Anchorage, AKBuilt 1979 · S/N 20700572 N7321NMalad Aviation LLC · Bliss, IDS/N 18263105 N7321SRauber James S · Lincoln, MTBuilt 1976 · S/N 18265113 N7322SSueson Flying Inc · Wilmington, DEBuilt 1976 · S/N 18265114 N7323QYelderman Neil O · Guy, TXBuilt 1972 · S/N 18260963 N7324NLeonhardt Bonnie · Riverton, WYBuilt 1974 · S/N 18263108 N7325CPollard Seka A · Huntington, WVBuilt 1965 · S/N 18256400 N73266Macair Aviation LLC · Xenia, OHBuilt 1979 · S/N 20700574 N7326SState Of Alaska Department Of Public Safety · Anchorage, AKBuilt 1976 · S/N 18265117 N7327ELarsen James M · Santa Rosa, CABuilt 1959 · S/N 57027 N7328NPersonal Fliers Inc · Sterling Heights, MIBuilt 1974 · S/N 18263112 N7328SVersa Wings LLC · Port Saint Lucie, FLBuilt 1976 · S/N 18265119 N7329NRegent Trust Corp Trustee · Wichita, KSS/N 21063220 N7329QBooker Merle D · Connell, WABuilt 1972 · S/N 18260969 N7329SMoncourtois Mark T · Annandale, NJBuilt 1976 · S/N 18265120 N732ADDavis Billy E · Castlewood, SDBuilt 1976 · S/N 21061355 N732AQGold Star Air · Portland, MEBuilt 1976 · S/N 21061366 N732AVRomberg Wayne Dennis · Forked River, NJBuilt 1976 · S/N 21061371

Back to AD 84-10-01 R1