Skip to content

Registered aircraft · 2,375

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:82-06-11-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:82-06-11-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:82-06-11-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:82-06-11-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:82-06-11-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:82-06-11-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.

N44649Wofford Walter R · Auburn, CABuilt 1974 · S/N 28R-7435319 N4464TNelson Richard C · Euless, TXFirst renewal noticeBuilt 1972 · S/N 28R-7235022 N4465TSky-High Aviation LLC · Martinsburg, WVBuilt 1972 · S/N 28R-7235063 N4466XAlexander Michael P · Clute, TXBuilt 1975 · S/N 28R-7635052 N446TTC5 Aviation LLC · Sheridan, WYBuilt 1974 · S/N 28R-7435317 N4474XToledo City School District · Swanton, OHS/N 28R-7635054 N44754Greenville Pickens Roundtrac LLC · Easley, SCBuilt 1974 · S/N 28R-7535003 N44790Spence William M · Naples, FLBuilt 1974 · S/N 28R-7535007 N4479TSouthern Colorado Flight Professionals LLC · Pueblo, COBuilt 1972 · S/N 28R-7235033 N44802Page Aviation Services LLC · Fort Myers, FLS/N 28R-7535009 N4480TSell Justin L · Lucerne, INBuilt 1972 · S/N 28R-7235067 N44844Morland Robert L · Bowman, NDBuilt 1977 · S/N 28R-7703330 N44845N44845 LLC · Ozark, MOBuilt 1977 · S/N 28R-7703331 N4484XDelta Charlie Aviation LLC · Royal Palm Beach, FLBuilt 1975 · S/N 28R-7635056 N44859Tarcelo Francis Antonio G · Sun City, CABuilt 1977 · S/N 28R-7703333 N44862Red Arrow III LLC · Carson City, NVBuilt 1977 · S/N 28R-7703335 N4486FRegistration Pending · Hague, VARegistration pendingBuilt 1976 · S/N 28R-7635411 N44887Gabriel Robert A · Lancaster, PABuilt 1977 · S/N 28R-7737149 N44889Gray Bradley D · Killeen, TXBuilt 1977 · S/N 28R-7703336 N4488TN4488t LLC · Newport Beach, CABuilt 1972 · S/N 28R-7235035 N44891Rci Asset Management Inc · San Diego, CABuilt 1977 · S/N 28R-7703339 N448PValiair Limited Company · Casper, WYS/N 28R7703058 N44903Treehouse Aviation LLC · Tuscaloosa, ALBuilt 1977 · S/N 28R-7703341 N44941Herboldsheimer Dixon · Westminster, COBuilt 1977 · S/N 28R-7703344 N44962Johnson Bud W · Cedar City, UTBuilt 1977 · S/N 28R-7703350 N44966Gillette Scott A · Lancaster, CABuilt 1977 · S/N 28R-7703351 N4497FMurray David J · Waymart, PABuilt 1976 · S/N 28R-7635412 N4497TArrow97t Llp · Feeding Hills, MABuilt 1972 · S/N 28R-7235042 N4498TCunniff Jack S · Weymouth, MAFirst renewal noticeBuilt 1972 · S/N 28R-7235045 N44995Fenton Flyers LLC · Ellisville, MSS/N 28R-7703352 N449DWWalt David L · Clarkston, MIFirst renewal noticeBuilt 1977 · S/N 28R-7703349 N449DYRanjit Pearlinda · Apex, NCBuilt 1972 · S/N 28R7235200 N44AYPartin Kathy L · Nacogdoches, TXS/N 28R-7535012 N44KDSale Reported · Crystal, MNSale reported, canceledBuilt 1972 · S/N 28R-7235106 N44SMHinds Community College · Raymond, MSBuilt 1976 · S/N 28R-7635076 N4507RFly First LLC · West Memphis, ARBuilt 1979 · S/N 28R-7918246 N4509XPerformance Power Services Pc · Naperville, ILBuilt 1975 · S/N 28R-7635067 N4511NOliver Stephen F · Spring Branch, TXBuilt 1979 · S/N 28R-7918248 N4511SConner Gary Dean · Cypress, TXBuilt 1979 · S/N 28R-7931287 N4513FDeripaska Gary Stanley · Owasso, OKBuilt 1976 · S/N 28R-7635413 N4516XMckown Martin H · Ocean City, MDBuilt 1975 · S/N 28R-7635068 N4521TSpencer Kevin L DBA · Bend, ORBuilt 1972 · S/N 28R-7235077 N4524XSharp Jacob · El Paso, TXBuilt 1975 · S/N 28R-7635069 N4526TBoal Ronald O · Mooresburg, TNBuilt 1972 · S/N 28R-7235078 N4528FPhoenix Aviation Solutions LLC · Clarksville, TNBuilt 1976 · S/N 28R-7635414 N4531FOneill Robert J · Rocklin, CABuilt 1976 · S/N 28R-7635415 N4534X4534xray Flyers Ltd · Lima, OHBuilt 1975 · S/N 28R-7635071 N4541TUniversal Technical Institute Inc · Miramar, FLS/N 28R-7235083 N4541XPeachtree Air LLC · Wilmington, DEBuilt 1976 · S/N 28R-7635073 N4544TJdc Aviation LLC · Upland, CABuilt 1972 · S/N 28R-7235085

Back to AD 82-06-11 R1