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.

N6262WRegistered aircraftBuilt 1964 · S/N 28-20293 N6263CKasallis Thomas G · Midlothian, TXBuilt 1978 · S/N 28R-7803215 N6263JMcclain Family Cellars Inc DBA · Irvine, CABuilt 1976 · S/N 32R-7680344 N6268JGaal Stephen E · O Neals, CABuilt 1976 · S/N 28-7615351 N6268WTereshchenkov Nikita · Edgewood, WABuilt 1964 · S/N 28-20316 N6269CBorck Benjamin · Bala Cynwyd, PABuilt 1978 · S/N 28-7816402 N626BCherokee Family Limited Partnership · Watsonville, CABuilt 1964 · S/N 28-2094 N626BPBroburg Gregory W · Minneapolis, MNBuilt 1977 · S/N 28-7790552 N626CPPenn Flight Academy LLC · Quakertown, PABuilt 1979 · S/N 28-7990396 N626MAJefferson City Aviation Inc · Jefferson City, MOBuilt 1996 · S/N 28-43026 N626MJGreathouse Nicholas Lee · Casa Grande, AZBuilt 1976 · S/N 28-7625134 N626NJCohesive Aviation LLC · Gilford, NHBuilt 1974 · S/N 28-7415292 N626PMMckivergan Michael · Yuma, AZBuilt 1967 · S/N 28-4098 N626RNFerguson & Son Inc · Lebanon, TNBuilt 1967 · S/N 32-40246 N6270JGabel Douglas L · Hillsboro, ORBuilt 1976 · S/N 28-7690387 N6270WMaple City Aviatiors LLC · Laporte, INBuilt 1964 · S/N 28-20318 N62715Probst Vincent G · Lutz, FLBuilt 1967 · S/N 28-23382 N6271JG&M Aircraft Inc · Wheat Ridge, COS/N 28-7690388 N6273JLance J Piper LLC · Green Bay, WIBuilt 1976 · S/N 32R-7680346 N6273WBelfino Nicholas E · Dallas, PABuilt 1964 · S/N 28-20322 N6275YAg Air Squadron Two LLC · St Joseph, ILBuilt 1969 · S/N 28R30079 N6276WCable Philip L · Cable, WIS/N 28-20326 N6277JSwigart Kurt M · Poulsbo, WABuilt 1976 · S/N 28-7615353 N6277WMcnew John P · Brighton, COBuilt 1964 · S/N 28-20327 N6278WSummars Roger N · Buffalo, OKBuilt 1964 · S/N 28-20328 N6279Wings Of Grace LLC · Orlando, FLBuilt 1965 · S/N 28-21148 N6279JWinemiller Todd L · Blanchester, OHBuilt 1976 · S/N 28-7610139 N6279WArtus Stephen Douglas Jr · Pelican Lake, WIBuilt 1964 · S/N 28-20329 N627AAPeregrine Howard Partners II Lp · New Orleans, LABuilt 2023 · S/N 2881627 N627BBPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010045 N627FDPacific Health Care Staffing Inc · Rancho Cucamonga, CABuilt 1978 · S/N 28R-7803187 N627FGGulla Frank W Jr · The Villages, FLBuilt 1981 · S/N 28R-8118062 N627FTFlorida Institute Of Technology · Melbourne, FLBuilt 2001 · S/N 2842131 N627WBIllini Enterprises LLC · Cherry Valley, ILBuilt 1979 · S/N 28-7911233 N6281CMiloud Chadd K · Fort Worth, TXBuilt 1978 · S/N 28-7816403 N6281WFugate Robert S II · Scottsdale, AZBuilt 1964 · S/N 28-20331 N6282JLutter James L · Gann Valley, SDBuilt 1976 · S/N 32R-7680349 N6282WSale Reported · Carthage, MSSale reportedS/N 28-20332 N6283WEfficientflight Aviation LLC · Naples, FLBuilt 1965 · S/N 28-21262 N6284WWd Environmental Services Inc · Wauchula, FLBuilt 1964 · S/N 28-20224 N6286JGunstream Jesse B III · League City, TXBuilt 1976 · S/N 28-7615357 N6286WWestern Plains Aviation LLC · Greeley, COBuilt 1964 · S/N 28-20242 N6287JAdil Junaid · Tucson, AZBuilt 1976 · S/N 28-7690392 N6287WHobbs Jason · Saint Francisville, LABuilt 1964 · S/N 28-20245 N6288JIxi LLC · West Bloomfield, MIBuilt 1976 · S/N 28-7690393 N6288WRegistration Pending · Fort Lauderdale, FLRegistration pendingS/N 28-20254 N6289JS K Bound LLC · Missoula, MTBuilt 1976 · S/N 28R-7635332 N6289WCronk Howard · Council Bluffs, IABuilt 1964 · S/N 28-20233 N628FTFlorida Institute Of Technology · Melbourne, FLBuilt 2001 · S/N 2842124 N6290JMclaen Family LLC · Queen Creek, AZBuilt 1976 · S/N 28R-7635333

Back to AD 87-08-08 R3