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.

N96218Link Jessica Elizabeth · Castalia, OHBuilt 1967 · S/N R172-0214 N962GHHart Gary L · Fernwood, IDBuilt 1997 · S/N 95-001 N9637VAllen Linda M · Amarillo, TXBuilt 1977 · S/N R1722339 N963PMAranha Jason Piotrowski · Los Angeles, CABuilt 1988 · S/N 25-1158 N963WMMorrison William S · Aliquippa, PABuilt 1980 · S/N R1723344 N9659VAitken Lyle W · Tuscaloosa, ALBuilt 1977 · S/N R1722344 N96706Cordingley Robert Lee · Lafayette, COBuilt 2001 · S/N 1116 N9678CUfnn Aviation LLC · Lake Charles, LAS/N 34-7870208 N967DPAct2 Aviation LLC · Herndon, VABuilt 2003 · S/N 1287 N9681VCooperative Cross Roads Flying Club · Albuquerque, NMBuilt 1977 · S/N R1722346 N96890Llewellyn James R · Bainbridge Island, WAS/N R172-0118 N968RAVan Buren Warren E · Blairsville, GABuilt 2005 · S/N 1492 N9692VShow Low Flight Academy LLC · Show Low, AZBuilt 1977 · S/N R1722347 N9699HDamschroder Rex A · Fremont, OHS/N 337-0395 N969HDHangar One Lc · Clear Lake, IABuilt 2004 · S/N 1404 N969WAMiloud Chadd K · Fort Worth, TXBuilt 1980 · S/N 348070112 N96CJJones Christopher W · Portland, ORBuilt 2011 · S/N 21577 N96PGWood David L · Lubbock, TXBuilt 1977 · S/N 34-7770277 N96STEwing Don · Colton, CAS/N ST-1 N9724CGlobal Capital Partners LLC · Tualatin, ORBuilt 1978 · S/N 28R-7803276 N97258Cass Flying Venture Inc · Wilmington, DEBuilt 1981 · S/N 25-0505 N972QJInvictus Health LLC · Yorktown, VAFirst renewal noticeBuilt 1978 · S/N 28R7803366 N9731KAnywhere Atp LLC · Mt Juliet, TNBuilt 1977 · S/N 34-7870036 N97353Jk Aviation LLC · Batavia, ILBuilt 1981 · S/N 25-0509 N97429Leblanc Scott G · Red Bluff, CABuilt 1981 · S/N 25-0512 N9759UBrockett Joe · Hubbard, TXBuilt 1981 · S/N 25-0517 N9764SSmith Kenneth W · Bedford, INS/N 25-0519 N976AWConnolly Luke A · Blaine, MNBuilt 1969 · S/N 337M0442 N9775VRegistered aircraftBuilt 1981 · S/N 25-0522 N977SFAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1979 · S/N 347970169 N9798CWeather Modification LLC · Fargo, NDBuilt 1978 · S/N 34-7870222 N979WA700p LLC · Lewes, DEBuilt 1979 · S/N 34-8070109 N97CHBroersma Charles B · Farmington, NYS/N 25-1120 N97NMInternational Air Services Inc Trustee · Carson City, NVBuilt 1986 · S/N 251047 N9801YVenture Aircraft Management LLC · St Petersburg, FLBuilt 1981 · S/N 25-0526 N9804MHastie John L III · Bethel, AKBuilt 1965 · S/N 1037 N9807YStein Ronald D · Soda Springs, IDBuilt 1981 · S/N 25-0528 N9808MGerling Matthew Karl · Eagle River, AKS/N 1041 N9810MPakuer Levi R · Salmon, IDBuilt 1966 · S/N 1020C N9813MGagnebin Michael · Steamboat Springs, COBuilt 1965 · S/N 1036 N98184Gotto Timothy M · Fairview Heights, ILBuilt 1981 · S/N 25-0529 N9819MBurnett Scott L · Roswell, NMBuilt 1966 · S/N 1005C N9826MBreitbach Perry J · Circle, MTBuilt 1966 · S/N 1010C N9830MChaney George M · Tellico Plains, TNBuilt 1966 · S/N 1015C N9834MConklin Gregory D · Nevada City, CABuilt 1966 · S/N 1-S N9839MRegistered aircraftS/N 1027C N9840MBlackstone Christopher M · Oregon City, ORBuilt 1966 · S/N 1022C N98444Mach .26 LLC · Denver, COBuilt 1981 · S/N 25-0533 N98498Cnb Collectibles Family Lp · Reno, NVBuilt 1981 · S/N 25-0534 N9849MAndersen Chris · Forest Grove, ORBuilt 1966 · S/N 1032C

Back to AD 81-13-10 R1