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.

N612WTPlane Leasing LLC · Tempe, AZBuilt 1978 · S/N 28-7816655 N6130JUtley Gary D · Okmulgee, OKFirst renewal noticeBuilt 1976 · S/N 28-7615307 N6131JDotson Tem · Hindsville, ARBuilt 1976 · S/N 28-7615308 N6132JWolf Aviation Network Inc · Westfield, MABuilt 1976 · S/N 28-7615309 N6133JArbello Danny · Sterling, VAS/N 28-7615310 N6134WRegistration Pending · Mesa, AZRegistration pendingBuilt 1964 · S/N 28-20151 N6135WWhiskey Aviation LLC · Huntsville, ALBuilt 1964 · S/N 28-20152 N6136JTennessee Flight Academy LLC · Bristol, TNBuilt 1976 · S/N 28R-7635301 N6137JBradford III Properties LLC · Huntersville, NCBuilt 1976 · S/N 32R-7680309 N6137WPrepmasters Inc · Boynton Beach, FLS/N 28-20134 N6138JLockwood Elijah T · Dayton, OHBuilt 1976 · S/N 32R-7680310 N6138VGlover Michael M · Mechanicsville, VABuilt 1968 · S/N 28-23988 N6139WFleetwood James D · French Lick, INBuilt 1964 · S/N 28-20157 N613ACBas Part Sales LLC · Greeley, COBuilt 2014 · S/N 2843757 N613DBTigner Steven M · Leesburg, FLBuilt 1999 · S/N 3257091 N613FLOwens William N · Lexington, NCBuilt 1971 · S/N 28-7125492 N613SMWiff Robert A · Tahuya, WABuilt 1981 · S/N 32R-8129034 N6140HDiaz Jesse · Dothan, ALBuilt 1977 · S/N 28R-7803089 N6140JWeldy Mark L · Etna Green, INBuilt 1976 · S/N 28-7615311 N6140WKing Donna K · Mount Pleasant, MIBuilt 1964 · S/N 28-20158 N6141JRnt Air LLC · Mitchell, SDBuilt 1976 · S/N 28-7615312 N6142WBurns Robert J · Loxahatchee, FLBuilt 1964 · S/N 28-20160 N6144WFiebelkorn Daniel S · Gregory, SDBuilt 1964 · S/N 28-20162 N6145WRegistered aircraftS/N 28-20163 N6147HBietsch Sr Thomas R · Lincoln, CABuilt 1977 · S/N 28-7816229 N6147WLister Stephen J · Sherman, ILBuilt 1964 · S/N 28-20166 N6148HHicks Braden · Manson, IABuilt 1977 · S/N 28-7816230 N6148JNorth Texas Flight Ventures LLC · Mckinney, TXBuilt 1976 · S/N 28-7615313 N6148WAir Ventures Flying School LLC · Smithfield, RIBuilt 1964 · S/N 28-20167 N614973 Dudes 1 Plane LLC · Olympia, WABuilt 1976 · S/N 28-7625109 N6149JAeroventures Flying Club Inc · Lilburn, GABuilt 1976 · S/N 28-7615314 N614BLWingsleasing LLC · Wichita, KSBuilt 2025 · S/N 2881856 N614FLEagle Sky Patrol Inc · Deadwood, SDBuilt 1971 · S/N 28-7125493 N614PSAeronaut Technolgy LLC · Jacksonville, FLS/N 28-7415134 N614SCRunamuck LLC · New Orleans, LABuilt 2023 · S/N 2881623 N614WTJamestown Jet Center Inc · Jamestown, NDBuilt 1968 · S/N 28-23777 N614XGMaher Jay A · Highlands Ranch, COBuilt 1977 · S/N 28R-7703262 N6150JCypress Aviation LLC · Malvern, PAS/N 28-7690353 N6151HFly Aviation Corp · Wilmington, DEBuilt 1977 · S/N 28-7890211 N6152WRogers Samuel I · Leroy, KSBuilt 1964 · S/N 28-20171 N6153JLange Scott A · Rapid City, SDBuilt 1976 · S/N 28R-7635303 N6154HTravis Air Force Base Aero Club · Travis Afb, CABuilt 1977 · S/N 28-7890212 N6156WHousley Steven W · Hot Springs, SDS/N 28-20175 N6157JSale Reported · Columbus, OHSale reportedBuilt 1976 · S/N 28-76-25224 N6157WLaminar Skies Aviation LLC · Broken Arrow, OKBuilt 1964 · S/N 28-20176 N6159HJeva Ventures LLC · Charleston, SCBuilt 1977 · S/N 28R-7837055 N6159JSmathers James R Jr · Mission Viejo, CABuilt 1976 · S/N 28-7615316 N6159WSale Reported · San Luis Obispo, CASale reportedBuilt 1964 · S/N 28-20178 N615DCSheeree Corp · Wilmington, DES/N 28-7716178 N615FTFlorida Institute Of Technology · Melbourne, FLBuilt 1980 · S/N 28-8116123

Back to AD 87-08-08 R3