Skip to content

Registered aircraft · 22,413

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N3921TLittlehailes Roderick A Trustee · Solvang, CAS/N 28R-30258 N3921WJohnson Roger D · Fort Meade, FLBuilt 1967 · S/N 32-868 N3921XBurger Paul D · Cypress, TXBuilt 1975 · S/N 28R-7535353 N3922WSteffey John · Saint Augustine, FLBuilt 1967 · S/N 32923 N3923REagle Aeronautics LLC · Chicago, ILBuilt 1970 · S/N 28-5831 N3923XFerriero Bruce C · Danvers, MABuilt 1975 · S/N 28R-7535354 N3924TRaw Racing Inc · Puyallup, WABuilt 1967 · S/N 28R-30262 N3924WFrazier Shannon Leo · De Witt, IABuilt 1967 · S/N 32-871 N3924XAxelson Peter G · Hot Springs, ARBuilt 1976 · S/N 28-7610001 N3925KDte Aviation LLC · Cherry Hill, NJS/N 28-23797 N3925TElevation Air LLC · Amelia, OHBuilt 1967 · S/N 28R-30263 N3925WFrench Nathan E · Wilmington, NCS/N 32-924 N3926KWatson Michael · Reedsville, PABuilt 1967 · S/N 28-23798 N3926RBrowning Philip L · Beatrice, NEBuilt 1970 · S/N 28-5849 N3926TNewton Aviation LLC · Atlanta, GAFirst renewal noticeBuilt 1967 · S/N 28R-30264 N3927KNice James · Marysville, WABuilt 1967 · S/N 28-23799 N3928KHanneman Resa L · Denver City, TXBuilt 1967 · S/N 28-23801 N3928MSalter James A · San Luis Obispo, CABuilt 1978 · S/N 28R-7803201 N3928TBarnett Rodney · Rockwood, TNBuilt 1967 · S/N 28R-30267 N3928XVanness Aviation LLC · Lawton, NDBuilt 1975 · S/N 28R-7535355 N3929FRadaskiewicz Mark D · Gilbert, AZBuilt 1976 · S/N 32R-7680420 N392DNational Training 1 LLC · Wilmington, DEBuilt 2016 · S/N 2843850 N392HPAd Flight Training LLC · Altamont, NYBuilt 2005 · S/N 3257387 N3930KQuick Jeremy R · Bremen, INBuilt 1967 · S/N 28-23803 N3930RGillett Darrin L · Cedar Falls, IAS/N 28-5848 N3930WAvionics Holding Group LLC · Salisbury, NCBuilt 1967 · S/N 32-878 N3931KAlpha 1 Aviation LLC · Helena, ALS/N 28-23804 N3931THall Charles H · Belleville, MIBuilt 1967 · S/N 28R-30270 N3932TAhles David R · Tellico Plains, TNBuilt 1967 · S/N 28R-30271 N3932XCarbon Six LLC · San Diego, CAS/N 28R-7535356 N3933WHall James A III · Lagrange, KYBuilt 1967 · S/N 32-882 N3934WStudio Jet Inc · Valley Village, CABuilt 1967 · S/N 32-883 N3935KKrog Steven L · Hartford, WIBuilt 1967 · S/N 28-23809 N3935WAmbrosio Phillip · Saint Louis, MOBuilt 1967 · S/N 32-884 N3936MAtd Pilot Training LLC · Kansas City, MOBuilt 1978 · S/N 28-7816386 N3936TGreen Castle Aero Club Ltd · Oxford, IABuilt 1967 · S/N 28R-30277 N3936WStahl Michael Ray Jr · Pleasant City, OHS/N 32-928 N3937WBowen Wesley B · Dothan, ALBuilt 1967 · S/N 32-886 N3938KCdb Group Holdings LLC · Sheridan, WYBuilt 1967 · S/N 28-23813 N3938WAugust Aero LLC · Kalispell, MTBuilt 1967 · S/N 32-887 N3939KRegistration Pending · Grand Prairie, TXRegistration pendingBuilt 1967 · S/N 28-23814 N3939RReid Edwin G Jr · Hollywood, MDBuilt 1970 · S/N 28-5850 N3939TDespins David R · Gray, MES/N 28R-30281 N3939XArapahoe Flight Club LLC · Colorado Springs, COBuilt 1975 · S/N 28-7515434 N393BTPiper Aircraft Inc · Vero Beach, FLS/N 28010094 N393DNational Training 1 LLC · Wilmington, DEBuilt 2016 · S/N 2843851 N393MMN393mm LLC · Stillwater, OKBuilt 2000 · S/N 3257168 N3940KAir Ventures Flying School LLC · Smithfield, RIBuilt 1967 · S/N 28-23764 N3940MCondair Flyers Inc · Latham, NYBuilt 1978 · S/N 28-7816388 N3941KHawkins Allan S · Lizella, GABuilt 1967 · S/N 28-23816

Back to AD 87-08-08 R3