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.

N78096Bell Michael S · Trinity, TXBuilt 1946 · S/N 2096 N78198Ryan Adrian B · Anchorage, AKBuilt 1990 · S/N 001 N781CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2004 · S/N 1423 N781WWMattson William W · Telluride, COBuilt 1977 · S/N 28R-7803090 N783BGAir Shares LLC · Casper, WYBuilt 2001 · S/N 17281021 N783CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N 1573 N783SFBremfour Aviation Group Inc · Wilmington, DEBuilt 2001 · S/N 172S8980 N7842FIso Art Ltd · Hamilton, MTS/N 28R-7703004 N785CGWings Of Victory Worldwide LLC · Apopka, FLS/N 34-7770351 N7866NUnited States Air Force · Colorado Springs, COBuilt 1967 · S/N R172-0257 N7867NUnited States Air Force Owner · Kirtland Afb, NMBuilt 1968 · S/N R172-0258 N7869NSale Reported · Millington, TNSale reportedBuilt 1967 · S/N R172-0260 N786MSKing Kimberly A · Kensington, NHBuilt 1999 · S/N 3449114 N7870NUnited States Air Force Owner · Colorado Springs, COBuilt 1967 · S/N R172-0261 N7872NUnited States Air Force Owner · Holloman Afb, NMBuilt 1967 · S/N R172-0263 N7873NUnited States Air Force · Colorado Springs, COBuilt 1967 · S/N R172-0264 N7874NUnited States Air Force Owner · Colorado Springs, COBuilt 1967 · S/N R172-0265 N787SECordes Stefan F · Bethesda, MDBuilt 1987 · S/N 251042 N787TRManage It LLC · Orange, CABuilt 2010 · S/N 72385 N787WAJw Aero Holdings Inc · Canandaigua, NYBuilt 1980 · S/N 348070057 N7881NU S Air Force-Owner · Holloman Afb, NMBuilt 1967 · S/N R172-0272 N7882NUnited States Air Force · Kirtland Afb, NMBuilt 1967 · S/N R172-0273 N7884NUnited States Air Force Owner · Usaf Academy, COBuilt 1967 · S/N R172-0275 N7886NLake Area Technical Institute · Watertown, SDBuilt 1967 · S/N R172-0277 N7887NUnited States Air Force · Kirtland Afb, NMBuilt 1967 · S/N R172-0278 N7889NDutchess Community College · Poughkeepsie, NYS/N R172-0280 N788JNBas Part Sales LLC · Greeley, COBuilt 2004 · S/N 1427 N7891NUnited Statesair Force · Travis Afb, CAS/N R172-0282 N7899NUnited States Air Force Owner · Colorado Springs, COBuilt 1968 · S/N R172-0290 N789GAProctor John · Rosebud, TXS/N 2346 N78KDFoster John W · Bend, ORBuilt 1978 · S/N MC-569 N78RCAviaries LLC · Sun Prairie, WIBuilt 2002 · S/N 1259 N78SMZimmerman Gregory J · Iowa City, IABuilt 1968 · S/N 337-1046 N78XPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N 0603 N7900NWarren County Sheriffs Dept · Mcminnville, TNBuilt 1968 · S/N R172-0291 N7902NUnited States Air Force Owner · Colorado Springs, COBuilt 1968 · S/N R172-0293 N7903NUnited States Air Force · Usaf Academy, COBuilt 1968 · S/N R172-0294 N7905NUnited States Air Force Owner · Peterson Afb, COBuilt 1968 · S/N R172-0296 N7906NHuppert Zachary D · Melbourne Beach, FLS/N R172-0297 N7909NUnited States Air Force Owner · Colorado Springs, COBuilt 1968 · S/N R172-0300 N7922TMeadow Mountain Logistics LLC · Snowmass Village, COBuilt 1960 · S/N 56622 N7927SFarag Abdelrahman · Milwaukee, WIBuilt 2001 · S/N 1162 N793DSDale Aviation LLC · Wilmington, DES/N 33701376 N7951GJespersen James A · Iowa City, IABuilt 2001 · S/N 1158 N797FBellmann Carl W · Bryan, OHBuilt 1983 · S/N 81-101 N797KWDawson Wayne R · Arlington, TXBuilt 2007 · S/N 72288 N797MTJib Inc · Groton, CTBuilt 1978 · S/N 34-7870433 N797TLTerra Luna Transportation Inc · West Palm Beach, FLBuilt 2003 · S/N 1329 N799JHInternational Air Services Inc Trustee · Carson City, NVBuilt 1982 · S/N 28R-8231051 N79AFBritsch Uwe K · Klamath Falls, ORBuilt 1979 · S/N 28R-7931265

Back to AD 81-13-10 R1