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.

N2350MCampbell J Bryce · Stillwater, OKBuilt 1977 · S/N 28R-7803125 N2354SSkymaster Stc LLC · Mena, ARBuilt 1967 · S/N 337-0654 N235DRJones Mark A · Litchfield Park, AZBuilt 1985 · S/N 25-0889 N2360Adams Courtney E · Tampa, FLS/N 0100 N2362SMclaren Institute Of Transporation Technologies · Goode, VABuilt 1967 · S/N 337-0662 N2366SDaughtrey Kevin E · Arcadia, FLS/N 337-0666 N236CFGriswold Joshua P · Los Angeles, CABuilt 1976 · S/N 34-7770091 N23777Erb Ralph J · Mebane, NCS/N R1720096 N23788Bellendir Timothy J · Fort Morgan, COBuilt 1967 · S/N R172E-0092 N237AMMcconnell Edward H · Weatherford, TXBuilt 1990 · S/N 79 N2382SMielczarek Joe I · Santa Paula, CABuilt 1967 · S/N 337-0682 N2397SState Of Wisconsin · Madison, WIBuilt 1967 · S/N 337-0697 N2398SBowser Earle Stephen · Arcata, CABuilt 1967 · S/N 337-0698 N23JCJet & Rotor Aviation LLC · Sacramento, CABuilt 1980 · S/N 348070121 N23LEMidstate Aviation 1 LLC · Owosso, MIBuilt 1981 · S/N 28R-8231021 N23XGUsda Forest Service Fepp · Malvern, ARBuilt 1967 · S/N R1720163 N2403BDmm Airshows LLC · Wilmington, DEBuilt 1949 · S/N 3703 N240SShook Wayland R · Ocala, FLBuilt 2013 · S/N 001 N2412MChristensen Broadcast Group Inc · Watertown, SDBuilt 1977 · S/N 28R-7803127 N2413SQualitair LLC Trustee · MichelstadtBuilt 1967 · S/N 337-0713 N2417SPiasecki Aircraft Corporation · Coatesville, PABuilt 1967 · S/N 337-0717 N2418SThomas Michael Ray · Marshall, MOBuilt 1967 · S/N 337-0718 N241HPWest Palm Breathe Free And Wellness LLC · West Palm Beach, FLBuilt 1984 · S/N 25-0804 N2427Boomer Aviation Inc · Fort Walton Beach, FLBuilt 1967 · S/N R172-0235 N242BBN242bb Inc · Fort Lauderdale, FLBuilt 1980 · S/N 25-0485 N242PSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2003 · S/N 1306 N242WSRowe William S · Argyle, TXBuilt 1967 · S/N R172-0243 N2432SKraemer Richard A · Hollywood, FLBuilt 1968 · S/N 337-0732 N2436SCranney Dan Gordon · Sevier, UTBuilt 1967 · S/N 337-0736 N243CDSojourn Flight LLC · Rapid City, SDBuilt 2002 · S/N 1252 N243MBSwanson Timothy J · Bannister, MIBuilt 1967 · S/N 337-0813 N2443SGill Robert S · Prudhoe Bay, AKFirst renewal noticeBuilt 1967 · S/N 337-0743 N2448MSnider Robert Douglas Daniel · French Camp, CABuilt 1977 · S/N 28R-7803130 N2457SAviation Specialty Services LLC · Beaufort, NCBuilt 1967 · S/N 337-0757 N245CBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1982 · S/N 34-8333007 N2462SLyon Joseph K · Mccall, IDBuilt 1967 · S/N 337-0762 N246BMBlue Oasis Flight Support · Tamarac, FLBuilt 1978 · S/N 34-7870083 N246BTGentile Keith · Riverton, UTBuilt 1967 · S/N 337-0769 N246CTThomas Charles E · Mokena, ILBuilt 1999 · S/N 23597 N246DDSmart Roger M · Hot Springs, ARBuilt 2011 · S/N 82884 N2474SEllison William K · Tipton, INBuilt 1967 · S/N 337-0774 N2485SBrewer Lester A · Magna, UTS/N 337-0785 N2486SDarvek LLC · Las Vegas, NVBuilt 1967 · S/N 337-0786 N248HRidge Line Aviation LLC · Denver, COBuilt 1975 · S/N 6080C N248LTOconnell Christopher · Tucson, AZBuilt 1975 · S/N 34-7570019 N2491SGeorge Ladelle L · Ashley, NDBuilt 1967 · S/N 337-0791 N249TMSchellberg Steven A · Port Matilda, PABuilt 2003 · S/N 1333 N24BTRutan Elbert L · Mojave, CABuilt 1996 · S/N 001 N24DCCraig Joshua · Bonaire, GABuilt 1975 · S/N 33701640 N24WEPake Flying Services LLC · Felton, MNBuilt 1998 · S/N 3449071

Back to AD 81-13-10 R1