Skip to content

Registered aircraft · 54,015

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.

N756FCSunny Aviation Investments Inc · San Francisco, CABuilt 1979 · S/N R18201059 N756FMTope Transportation Co · Wasilla, AKFirst renewal noticeBuilt 1977 · S/N U20604056 N756FNLevitt Charles J · Dover Plains, NYBuilt 1977 · S/N U20604057 N756FUElyria Airport Partnership · Jensen Beach, FLBuilt 1977 · S/N U20604063 N756FZM And S 182 LLC · Torrance, CAS/N R18201069 N756GEAbraham Curtis L · Byron, WYBuilt 1979 · S/N R18201071 N756GFKlaiber Carl F · Concord, NCBuilt 1977 · S/N U20604074 N756GLLawrence Cyril Leonard · Merced, CABuilt 1979 · S/N R18201073 N756GWSparrow Group LLC · Cheyenne, WYS/N U20604089 N756GYLake Superior College · Duluth, MNBuilt 1979 · S/N R18201074 N756GZGlasow Zachary · Klamath Falls, ORBuilt 1979 · S/N R18201075 N756HC242 Six Logistics LLC · Wilmington, DES/N U20604095 N756HQMaricopa County Sheriffs Office · Phoenix, AZS/N U20604107 N756HRPeters Aire LLC · Brainerd, MNBuilt 1977 · S/N U20604108 N756HUReynolds Richard A · Marco Island, FLBuilt 1977 · S/N U20604111 N756HVGmlc Investors LLC · Santa Rosa, CAS/N R18201078 N756JAGv Air Inc · Medford, ORS/N U20604117 N756JBRocky Mountain Great Planes LLC · Loveland, COBuilt 1979 · S/N R18201080 N756JCBeluga LLC · Wasilla, AKBuilt 1977 · S/N U20604119 N756JGNeal J Mckenny Corp Inc · Fortuna, CABuilt 1977 · S/N U20604123 N756JLN756jl LLC · Virginia Beach, VABuilt 1979 · S/N R18201082 N756JPHjs Aviation LLC · Fort Collins, COBuilt 1979 · S/N R18201083 N756JRWings Of Anglers LLC · Biloxi, MSBuilt 1979 · S/N R18201084 N756JSRedline Engineering Inc · Greenwood, CABuilt 1979 · S/N R18201085 N756JTRackley Co Inc · Orland, CABuilt 1977 · S/N U20604134 N756JVRufus Briar Inc · Willow Spring, NCBuilt 1979 · S/N R18201087 N756JYLadnier Ronald R · Lone Tree, COBuilt 1979 · S/N R18201088 N756JZBrowne Thomas J · Grass Valley, CABuilt 1977 · S/N U20604140 N756KCScaletta Enterprises LLC · Middleton, WIBuilt 1977 · S/N U20604143 N756KPVne Holdings Group LLC · North Canton, OHBuilt 1977 · S/N U20604154 N756KQTorgerson Kristofer · Knoxville, TNS/N R18201094 N756KSSmart Ray · Burbank, CABuilt 1979 · S/N R18201096 N756KVBeckert Richard D · Lake Stevens, WABuilt 1979 · S/N R18201097 N756KZEight Two Tango Inc · Winchester, VABuilt 1979 · S/N R18201100 N756LCTaiga Mining Company Inc · Anchorage, AKBuilt 1977 · S/N U20604167 N756LQC2c Investments LLC · St George, UTBuilt 1979 · S/N R18201102 N756LRWingover Aviation Inc · Huntsville, ALBuilt 1979 · S/N R18201103 N756MAFly-N-Bus Aviation LLC · Parker, COBuilt 1977 · S/N U20604189 N756MHKlingel Jeffery S · Byron Center, MIBuilt 1979 · S/N R18201111 N756MNMoody Bible Institute Of Chicago · Spokane, WABuilt 1979 · S/N R18201116 N756MPEarp Kevin W · Eagle River, AKBuilt 1977 · S/N U20604202 N756MYRegistered aircraftBuilt 1977 · S/N U20604211 N756MZSchreck Lynn G · Elk City, OKBuilt 1977 · S/N U20604212 N756NDRegistered aircraftBuilt 1977 · S/N U20604216 N756NGPerrigue Thomas E · Bishop, TXBuilt 1977 · S/N U20604219 N756NPAmerican Financial Services Inc · Las Vegas, NVBuilt 1979 · S/N R18201119 N756NYKempton Larry G · Grand Junction, COS/N R18201122 N756PBQas Mile High LLC · Los Gatos, CAS/N R18201123 N756PFTaiga Mining Co Inc · Anchorage, AKBuilt 1977 · S/N U20604242 N756PKBuoy Michael · Magnolia, TXBuilt 1977 · S/N 18266029

Back to AD 87-20-03 R2