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.

N30114International Aviation Group LLC · Lake Wales, FLBuilt 1978 · S/N 28-7916076 N30117D & S Aviation LLC · Spring, TXBuilt 1978 · S/N 28-7916077 N3011KBravo Farm LLC · Dover, DEBuilt 1978 · S/N 32-7940023 N3011NLange Jonathan R · La Mesa, CAS/N 28-7911098 N3011WHall Larry C · Decatur, ALBuilt 1996 · S/N 28-43065 N3011XHanania-Stout Motorcars LLC · Chattanooga, TNBuilt 1979 · S/N 32-7940093 N3011ZBoe Arvid J · Langdon, NDBuilt 1979 · S/N 28-7916393 N30126Pilots Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1978 · S/N 28-7990084 N3012ABottoms Engineering & Service Inc · Frankfort, KYBuilt 1978 · S/N 28-7990112 N3012BThrowbacks LLC · Pueblo, COBuilt 1978 · S/N 28-7911016 N3012DArias Herman R · Waco, GAS/N 28-7916154 N3012LCwp Flight LLC · Lawton, OKBuilt 1979 · S/N 32-7940031 N3012NBirkenseer James J · Danville, CAS/N 28-7911099 N3013DMcclary Doug T · South Lyon, MIBuilt 1978 · S/N 28-7990170 N3013NAnderson John · Hollister, CABuilt 1979 · S/N 28-7911100 N3013WBrant Lee A · Penngrove, CAS/N 28R-7918085 N3013ZZakos Dean R · Middleton, WIBuilt 1979 · S/N 28-7916395 N30144Roberti Aviation Of Delaware Inc · Lighthouse Point, FLS/N 3257330 N30147G&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 28-7990085 N3014GWings Aircraft LLC · Anacortes, WABuilt 1978 · S/N 28-7911072 N3014HBad Dog Aviation Inc · Meridianville, ALBuilt 1978 · S/N 28-7916182 N3014XReasoner Michael L · Corvallis, ORBuilt 1979 · S/N 32-7940094 N3015DFlywell Flying Club Inc · Roseville, MNBuilt 1978 · S/N 28-7990171 N3015UCoastal Fliers Inc · El Cajon, CABuilt 1979 · S/N 28-7990335 N3016DHuybrechts Dirk J · Los Angeles, CAFirst renewal noticeBuilt 1978 · S/N 28-7911040 N3016MWild Wingdom LLC · Greenville, SCBuilt 1978 · S/N 28-7890284 N3016NParker James C · Rescue, CABuilt 1979 · S/N 32-7940038 N3016TWilson Michael L · Santa Maria, CABuilt 1979 · S/N 28-7916298 N3016WBramble And Schaffer Aviation LLC · Raleigh, NCBuilt 1979 · S/N 28R-7918086 N30173Tolman William C · Maryville, TNBuilt 1978 · S/N 32R-7887270 N30176Arce George S · Roswell, GABuilt 1978 · S/N 32R-7887271 N3017HDavis Ronald C · Bloomington, MNS/N 28-7916184 N3017KSwing Paul M · Scottsdale, AZBuilt 1979 · S/N 28-7921048 N3018ZGorman Robert L · Los Gatos, CABuilt 1979 · S/N 28-7916398 N30190N30190 LLC · Colorado Springs, COBuilt 1978 · S/N 32R-7887272 N3019KColorado Air LLC · Colorado Springs, COBuilt 1978 · S/N 32R-7987089 N3019YSheets Jeffrey M · Salmon, IDBuilt 1979 · S/N 28-7911148 N301AVJackson Charles A · Winchester, KYBuilt 1976 · S/N 28-7715070 N301BHTraxler Shane C · West Monroe, LABuilt 1997 · S/N 3246080 N301BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020284 N301CAFreiday Robert A · Kingman, AZBuilt 1967 · S/N 32-40178 N301ECF N A Aviation LLC · Wakefield, MABuilt 2025 · S/N 2881980 N301EEPacker William M III · Bloomfield Twp, MIS/N 32R-7780469 N301KARivard Robert M · Grand Haven, MIBuilt 1981 · S/N 32R8113020 N301KG217 Aviation LLC · Winchester, ILBuilt 1988 · S/N 3213017 N301KKBurris Timothy J · Fountain Inn, SCBuilt 1979 · S/N 32-7940092 N301PKHubbs Matthew · Huntersville, NCBuilt 1973 · S/N 32-7440064 N301PS3b1g Enterprises LLC · Phoenix, AZBuilt 1982 · S/N 32-8306007 N301RTSather Dean L · Amarillo, TXBuilt 1982 · S/N 32R-8229068 N301STTechnical Education Services Inc · Virginia Beach, VAS/N 28-25655

Back to AD 87-08-08 R3