Skip to content

Registered aircraft · 4,001

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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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.

N4618TWoolston Evan K · Belle Fourche, SDBuilt 1965 · S/N 1029 N4621TIrby Donald K · Cushing, TXBuilt 1965 · S/N 1033 N4624TEisel Adam A · Copenhagen, NYBuilt 1965 · S/N 1026 N462DATucker Leonard E II · Waller, TXBuilt 1968 · S/N 337-0950 N462MCCilliers Carlo R · Frederick, MDBuilt 2011 · S/N 1865 N4635KFinley Robert O · Dubois, WYBuilt 1976 · S/N R1722001 N464CDSr-2x Aircraft LLC · Fort Worth, TXS/N 1495 N4653KEastern Aviation Publishing Inc · Center Harbor, NHBuilt 1976 · S/N R1722004 N466AMBlue Skies Investments LLC · Eugene, ORBuilt 2005 · S/N 1530 N468BBVensure Air LLC · Las Vegas, NVS/N 1264 N468DEUtah State University Space Dynamics Laboratory · North Logan, UTBuilt 1967 · S/N 337M0312 N468JPDolan John · Babylon, NYBuilt 2002 · S/N 1261 N46BJBrowning Charles H III · Woodbine, MDBuilt 1999 · S/N 526 N4710HHamilton James R · Colorado Springs, COBuilt 1980 · S/N 25-0473 N47228Sg Holdings LLC · Grand Mound, IABuilt 1977 · S/N 28R-7703354 N472LCCactus Air Force LLC · Dayton, NVBuilt 1967 · S/N 337M0052 N472MTFlight 915 LLC · El Paso, TXBuilt 2013 · S/N 72924 N47339Grider Aviation Inc · Indianapolis, INS/N 28R-7703357 N47347Alaska Yukon Aviation Ministries Inc · Anchorage, AKBuilt 1977 · S/N 34-7770387 N47359Mcilquham Roderick L · Bolingbrook, ILBuilt 1977 · S/N 28R-7703361 N47361Magpie Inc · Rock Springs, WYBuilt 1977 · S/N 28R-7703363 N47366Turbo Aviation LLC · Marblehead, MABuilt 1977 · S/N 34-7770389 N4739TJohn Ross St · Anchorage, AKS/N 1003 N47404Mil2atp Inc · Pikeville, NCBuilt 1977 · S/N 34-7770392 N4740TGerdes Douglas R · Macon, GAS/N 1004 N47416Jarriel Investments Inc · Register, GABuilt 1977 · S/N 28R-7703373 N47418Billings Chris · Duncan, OKBuilt 1977 · S/N 28R-7703374 N47419Capp Kevin C · Boswell, PABuilt 1977 · S/N 28R-7703375 N47424Phoenix Aviation LLC · Alexandria, VAS/N 34-7770394 N4743TWeaver Matthew B · Kasilof, AKBuilt 1964 · S/N 1008 N47442Registration Pending · Columbus, NERegistration pendingS/N 28R-7703377 N47445Premier Capital Enterprises LLC · Hurricane, UTBuilt 1977 · S/N 28R-7703379 N47448Jib Inc · Groton, CTBuilt 1977 · S/N 34-7770396 N47459Thompson James David · Newborn, GABuilt 1977 · S/N 28R-7703383 N4745TLee Andrew L · Anchorage, AKBuilt 1965 · S/N 1015 N47471Piper N47471 LLC · Granby, COBuilt 1977 · S/N 28R-7703384 N4747TRegistered aircraftBuilt 1965 · S/N 1013 N474WASix Seat Single LLC · Dayton, OHBuilt 1981 · S/N 34-8133038 N47514Groves William K · Faith, SDBuilt 1977 · S/N 28R-7703387 N47536Angel Aviation Inc · Peoria, AZBuilt 1977 · S/N 34-7770412 N47537Registered aircraftBuilt 1977 · S/N 34-7770413 N47546Robnett Theodore J · Central Point, ORBuilt 1977 · S/N 28R-7703395 N47551E2 Ventures Inc · Pinehurst, NCBuilt 1977 · S/N 28R-7703398 N475KVAlexander John Charles · Meadville, PABuilt 2001 · S/N 1155 N47605Lovaas Darryl G Trustee · Crescent City, CABuilt 1977 · S/N 28R-7703406 N47631Ordway Daniel F · Corona, CABuilt 1977 · S/N 34-7770420 N47632Famalette Christopher · Havre De Grace, MDBuilt 1977 · S/N 28R-7703367 N47642Wes Hughes Corporation · Waldron, KSBuilt 1977 · S/N 28R-7703413 N47670Stanberry Wallace A · Shreveport, LABuilt 1977 · S/N 34-7770424 N47681C Mf Inc · Bloomington, ILBuilt 1977 · S/N 28R-7703421

Back to AD 81-13-10 R1