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.

N4940FJackson Christopher M · Clearwater, FLBuilt 1976 · S/N 28R-7635445 N4949FGregory Scott · Quincy, MABuilt 1976 · S/N 28R-7703002 N4951TVolaero Aviation LLC · Valdosta, GAS/N 28R-7235161 N495DSDelaware State University · Dover, DEBuilt 1997 · S/N 2844012 N4967SLambert Enterprises Inc · Minneapolis, MNS/N 28R-35687 N4967TN4967t LLC · Evansville, INBuilt 1972 · S/N 28R-7235164 N4970SMapoles Aviation · Pace, FLS/N 28R-35690 N4976SLogsdon David · Carmel, INBuilt 1970 · S/N 28R-35692 N4977SMatheaus Michael · Sequin, TXBuilt 1970 · S/N 28R-35696 N4979SDunn James J · San Ramon, CABuilt 1970 · S/N 28R-35698 N4980SGrenie Arles A · Richland Center, WIBuilt 1970 · S/N 28R-35699 N4981SLacallle Darren M · Dover, TNBuilt 1970 · S/N 28R-35701 N4984SLinair LLC · Lewes, DEBuilt 1970 · S/N 28R-35704 N4985TPope Donald R · Enid, OKBuilt 1972 · S/N 28R-7235167 N498CCShephard Russell Steven · Gallatin, TNBuilt 1976 · S/N 28R-7635447 N4994SSmith Thomas C · Norfolk, VABuilt 1970 · S/N 28R-35719 N4995SNova Aero LLC · Ontario, ORBuilt 1970 · S/N 28R-35720 N4996SChabrian Jerry W · Daytona Beach, FLBuilt 1970 · S/N 28R-35721 N4999SStaples Chad V · Efland, NCBuilt 1970 · S/N 28R-35724 N499AT And B Aviation LLC · Oregon City, ORBuilt 1979 · S/N 28R-7931091 N49HDSasnak Inc · Wichita, KSS/N 28R-7803104 N4BRRoberts Boyd · Celeste, TXBuilt 1973 · S/N 28R-7335423 N5002SAsasnoceu LLC · Fort Myers, FLBuilt 1970 · S/N 28R-35726 N5007SSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1970 · S/N 28R-35731 N500GLEumundi Trading Company · Wilmington, DEBuilt 1978 · S/N 28R7803284 N500NPVolare Air LLC · Palm Harbor, FLBuilt 1974 · S/N 28R-7435168 N5010SAeroflyte LLC · Glastonbury, CTBuilt 1970 · S/N 28R-35735 N5010TN5010t LLC · Arcadia, OKS/N 28R-7235171 N5013SFlightworks LLC · North Myrtle Beach, SCBuilt 1970 · S/N 28R-35740 N5013TDasilvafontoura Peterson · Santa Clarita, CABuilt 1972 · S/N 28R-7235173 N5019SGordon Patricia I · Desoto, TXS/N 28R-35751 N5020SSchneider Robert R · Fort Benton, MTS/N 28R-35753 N5020TBetlach Christopher Thomas · Kenmore, WABuilt 1972 · S/N 28R-7235175 N5023SSummit Arrow Adventures LLC · Peyton, COBuilt 1970 · S/N 28R-35759 N5024SGuy Timothy S · Henderson, NVBuilt 1970 · S/N 28R-35760 N5025SAir Cover Academy LLC · Frankford, MOBuilt 1970 · S/N 28R-35761 N5027SRatliff Thomas E · Tomball, TXS/N 28R-35771 N5027TMohre Steve G · Blakeslee, OHBuilt 1972 · S/N 28R-7235177 N5028SSmith David J · Elkhart, INBuilt 1970 · S/N 28R-35772 N5028TDrake Charles R · Claremore, OKBuilt 1972 · S/N 28R-7235178 N5029SChop Bert D · Oak Grove, LABuilt 1970 · S/N 28R-35775 N5031SBrodowsky Thomas · West Bloomfield, MIBuilt 1970 · S/N 28R-35790 N5033SGpsp Aviation LLC · Bronx, NYBuilt 1970 · S/N 28R-35762 N5034SPlattsmouth Aviation LLC · Plattsmouth, NES/N 28R-35801 N5035SReady Airways LLC · Roseville, CABuilt 1970 · S/N 28R-35766 N5036SArrow II Flyers LLC · Jacksonville, FLBuilt 1970 · S/N 28R-35804 N5037SGannon Gary L · Cumberland, WIS/N 28R-35781 N5038SRegistration Pending · Fort Worth, TXRegistration pendingS/N 28R-35806 N5041SZelener Howard M · Redlands, CABuilt 1970 · S/N 28R-35788 N5042SBlair & Company Aero Partners LLC · Raleigh, NCBuilt 1971 · S/N 28R-7135117

Back to AD 82-06-11 R1