Skip to content

Registered aircraft · 54,017

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

N42599Avco Patrol LLC · Lyndon, KSBuilt 1968 · S/N 18259098 N4259FGuynes Ronald A · Two Rivers, WIBuilt 1958 · S/N 46159 N4259LBrown Lawrence D · Memphis, TNBuilt 1966 · S/N 17254328 N4259VKurt Robert F · Rose Hill, KSS/N 18615 N425DBWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17266404 N425DLTotal Flight Aircraft Leasing LLC · Apex, NCBuilt 1979 · S/N 172RG0143 N425KAHerrmann Laura Jean Trustee · Saint Bonifacius, MNS/N 18268454 N425MBPauls Valley Fly Boys LLC · Davis, OKBuilt 1976 · S/N 18264927 N425MKNorth Star Aviation Inc · Mankato, MNBuilt 1977 · S/N 15280650 N425PRHorizon Technical Services Inc · Farmingdale, NYBuilt 1977 · S/N 18266202 N425RBAkguc Cengiz · Lantana, TXBuilt 1962 · S/N 18254214 N425TASkyhawks Inc · Westminster, COBuilt 1976 · S/N 18264951 N42604Lawrie Daniel A · Mesa, AZBuilt 1968 · S/N 18259100 N42606Ramon Jose J · West Palm Beach, FLBuilt 1968 · S/N 18259101 N42609Jcr Ag LLC · Frederick, OKBuilt 1980 · S/N 18803666 N4260FAyers Frank E · Coulee Dam, WABuilt 1958 · S/N 46160 N4260LTrueman Jeffrey A · Clear, AKBuilt 1966 · S/N 17254329 N4260QLevin Robert G · Roseburg, ORBuilt 1971 · S/N 17260160 N4260UGebhart Travis D · Meadow, SDBuilt 1963 · S/N 15060260 N4260VFranks Marvin L · Cedar Key, FLBuilt 1948 · S/N 18616 N42610Meadows Marcus · Anchorage, AKS/N 18052366 N42615N42615 LLC · Shorewood, ILBuilt 1968 · S/N 18259107 N4261FPeri Richard A · Burgess, VABuilt 1958 · S/N 46161 N4261LCochrane Warren H Jr · Carabaset Vly, MEBuilt 1966 · S/N 17254330 N4261VWells Bryan G · Stephenville, TXBuilt 1948 · S/N 18617 N42623Boulware Randall R Trustee · Bolivar, MOBuilt 1968 · S/N 18259110 N42625Tull Matthew W · Niceville, FLBuilt 1968 · S/N 18259112 N42627Henry Mark A · Dickinson, TXS/N 18259114 N4262ARamaswamy Ashok · Clearwater Beach, FLS/N 27105 N4262FHayton James B · Sedro Woolley, WABuilt 1958 · S/N 46162 N4262UCrump Matthew A · Weatherford, TXBuilt 1963 · S/N 15060262 N4262VKinzie Industries LLC · Alva, OKBuilt 1948 · S/N 18618 N42631Ga Elite LLC · Camarillo, CABuilt 1968 · S/N 18259115 N4263LCox Dennis J · Beach City, TXBuilt 1966 · S/N 17254332 N4263UAdam Johnson · Sunray, TXBuilt 1964 · S/N 15060263 N4263VUltra Flight LLC · Le Mars, IABuilt 1948 · S/N 18619 N42645Williams Ray H Jr Trustee · Austin, NVBuilt 1968 · S/N 18259120 N42647Glenwood Tank Facility LLC · Ramsey, MNBuilt 1968 · S/N 18259121 N42648Propwash 182 LLC · Visalia, CABuilt 1968 · S/N 18259122 N42649Skydive Harbor Springs Inc · Charlevoix, MIBuilt 1968 · S/N 18259123 N4264LMcguckin Michael C · Mesa, AZBuilt 1966 · S/N 17254333 N4264QAlbrecht Paul J · Mine Hill, NJBuilt 1971 · S/N 17260164 N4264UJones Craig R · Brighton, MIS/N 15060264 N4264VLubben Ryan D · Fergus Falls, MNBuilt 1948 · S/N 18620 N42652West Dennis M · Lexington Park, MDBuilt 1968 · S/N 18259124 N42653Stockwell William · Dowagiac, MIBuilt 1968 · S/N 18259125 N42655Hawes Pamela M · Lancaster, MABuilt 1968 · S/N 18259126 N4265CHunt Delbert O · Dillon, MTBuilt 1968 · S/N 15068178 N4265FRedding Steven R · Skiatook, OKBuilt 1958 · S/N 46165 N4265L1515 Aviation LLC · Burleson, TXBuilt 1966 · S/N 17254334

Back to AD 87-20-03 R2