Skip to content

Registered aircraft · 340

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:85-03-04-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:85-03-04-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:85-03-04-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:85-03-04-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:85-03-04-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:85-03-04-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.

N4875WPc Air Ventures Ltd · Wilmington, DES/N 14205 N4882WForrest Lawrence C · Granbury, TXS/N 14212 N4887WBern Paul J · Apple Valley, CABuilt 1977 · S/N 14217 N4892WTagliareni Joseph R · Lake Hopatcong, NJS/N 14222 N4895WTaylor Mark W · Amherst, NYBuilt 1977 · S/N 14225 N4897WGibson Kurt A · Fort Smith, ARBuilt 1977 · S/N 14227 N4898WSorce Angelo J · Dandridge, TNBuilt 1977 · S/N 14228 N4911W3js Aviation LLC · Wilmington, DEBuilt 1977 · S/N 14235 N4912WBaur Peter · Placida, FLS/N 14236 N4918WGorman Robert W · Oklahoma City, OKS/N 14242 N4921WForward Aero LLC · Thomasville, PABuilt 1977 · S/N 14245 N4928WL D Aviation LLC · Chesapeake, VABuilt 1977 · S/N 14251 N4931WPerry Clifton · Lacon, ILBuilt 1977 · S/N 14254 N4934WS&T Aircraft LLC · Lewes, DEBuilt 1977 · S/N 14256 N4940WKitt Consulting LLC · Boardman, OHBuilt 1977 · S/N 14262 N4943WKaufman Michael A · Upland, CAS/N 14265 N4944WHickory Hill Partners LLC · College Station, TXS/N 14266 N4945WBlueline Flight Systems LLC · Orlando, FLBuilt 1977 · S/N 14267 N4947WBloom Kevin Lynn · Freeport, FLBuilt 1977 · S/N 14269 N4959WSteverson Jill T · Newhebron, MSBuilt 1977 · S/N 14279 N4961WDreka Todd W · Wasilla, AKS/N 14281 N4963WCaride Jose A · Spring Hill, FLS/N 14283 N4965WMorcom Aviation Services Inc DBA · Everett, WAS/N 14285 N4968WBower Jeffrey L · Glenwood, NJS/N 14288 N4976WQualitair LLC Trustee · MichelstadtBuilt 1977 · S/N 14296 N49809Anderson Erik G · Deerfield Beach, FLBuilt 1976 · S/N 14055 N4981WJahn Kenneth Kris · Shingle Springs, CABuilt 1977 · S/N 14301 N4983WPappa Whiskey Victor LLC · Brandon, MSBuilt 1977 · S/N 14303 N4984FChuprinko John A · Centerburg, OHBuilt 1977 · S/N 14246 N4988SMosley Jerry · Las Vegas, NVS/N 13011 N4990WKennedy Terry P · Kingman, AZBuilt 1977 · S/N 14310 N4993WHamilton Robert A · Owensboro, KYBuilt 1977 · S/N 14313 N4995WAnderson Ryan L · Wadena, MNS/N 14315 N49ABFay William E · Washougal, WAS/N 13066 N4JYSuzuki Shoji DBA · San Jose, CABuilt 1976 · S/N 13080 N500DSBarletta Mark S · Winter Haven, FLBuilt 1977 · S/N 14231 N50BGStilson Scott · Ivins, UTBuilt 1976 · S/N 14184 N511CABas Part Sales LLC · Greeley, COS/N 14035 N515CADeerpark Valley Investments LLC · Georgetown, TXBuilt 1976 · S/N 14059 N519CASakitumi LLC · Wilmington, DES/N 14239 N526AWRegistration Pending · Shell Lake, WIRegistration pendingBuilt 1977 · S/N 14226 N535CAHanson Robert M · Riverside, CABuilt 1977 · S/N 14293 N54RRValentin Jose E · Murrieta, CABuilt 1976 · S/N 13107 N555LPAerodyme Corp · South Burlington, VTBuilt 1978 · S/N 14405 N555SSSkylink Group LLC · York, PABuilt 1976 · S/N 14045 N56CVVaughn Geoffrey · Brunswick, GABuilt 1976 · S/N 14017 N5796NClausing Howard · Menomonie, WIBuilt 1978 · S/N 14369 N57BHBester Eric M · Shelby, NCBuilt 1976 · S/N 14001 N5804NAvioneta LLC · Atwater, OHBuilt 1978 · S/N 14372 N5805NRmz Aviation LLC · Cartersville, GAS/N 14373

Back to AD 85-03-04 R2