Skip to content

Registered aircraft · 22,416

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.

N6824WRoberts John R Jr · Homestead, FLBuilt 1965 · S/N 28-20962 N6825JByrd Mark L · Belpre, OHBuilt 1976 · S/N 28-7615368 N6826WMartinak Charles J · Rehrersburg, PABuilt 1965 · S/N 28-20966 N6827WShort Final Aviation LLC · Branson, MOBuilt 1965 · S/N 28-20967 N6828JKdrd Holdings LLC · Texas City, TXBuilt 1976 · S/N 28R-7635337 N6828WOleary David L · Framingham, MABuilt 1965 · S/N 28-20968 N682ABPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010082 N682GMTwo Golf Mike LLC · Florida, NYBuilt 1979 · S/N 28-7916553 N682JAYale Companies LLC DBA · Indianapolis, INBuilt 2022 · S/N 28020082 N682LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881245 N682TFAir Fleet Holdings LLC · Addison, TXBuilt 2025 · S/N 2881882 N6832FJpf Ventures LLC · Owatonna, MNBuilt 1976 · S/N 28-7790165 N6832JHolseberg Properties LLC · Ridgeville, SCBuilt 1976 · S/N 32R-7680338 N6832WLitchfield Bobby Lee · Claremont, CAS/N 28-20973 N6833CTexins Flying Club · Mckinney, TXBuilt 1965 · S/N 28-3024 N6833FPatriot Aviation LLC · Huntington, INBuilt 1976 · S/N 28-7790166 N6833JHumphries Aviation LLC · Maysville, KYBuilt 1976 · S/N 28-7625244 N6834WFlores Lindenfelser Armando · Apache Junction, AZBuilt 1965 · S/N 28-20975 N6835JPronk Glen R · Crittenden, KYBuilt 1976 · S/N 28-7615371 N683FLPuhalla Matthew C · Shelton, NES/N 28-7125616 N683JAYale Companies LLC DBA · Indianapolis, INBuilt 2022 · S/N 28020083 N683LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881246 N6840JBeineke Paul · Marion, OHBuilt 1976 · S/N 32R-7680361 N6841WBoehm Darrell · Safford, AZBuilt 1965 · S/N 28-20984 N6842JOracle Aviation LLC · Omaha, NEBuilt 1976 · S/N 28-7625245 N6843WRhodes Michael J · Fresno, CABuilt 1965 · S/N 28-20986 N6844JHundshamer Sara M · Smithfield, UTBuilt 1976 · S/N 28-7615373 N6847JMarkle Rick S · Waddy, KYS/N 28-7690408 N6848JPrudent Paths LLC · Hillsborough, CABuilt 1976 · S/N 28-7690409 N6849JSecker David A · San Jose, CAFirst renewal noticeBuilt 1976 · S/N 28R-7635340 N684APiper Archer Three LLC · Wilmington, DEBuilt 2014 · S/N 2843780 N684FLRegistration Pending · Odenton, MDRegistration pendingBuilt 1971 · S/N 28-7125618 N684JAYale Companies LLC DBA · Indianapolis, INS/N 28020084 N684JKTta Logistics LLC · Christiansted, VIS/N 32-40537 N684LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881251 N684NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 2881151 N684RAArendale Richard O · Hattiesburg, MSBuilt 1968 · S/N 28-4695 N6850WDixon Holly R · Denton, NEBuilt 1965 · S/N 28-21005 N6851JHem Properties LLC · Winston Salem, NCBuilt 1976 · S/N 32R-7680370 N6852FBlue Sky Flying Club LLC · Granger, IABuilt 1976 · S/N 28-7790167 N6852WJurol Aviation Limited · Norwalk, OHBuilt 1965 · S/N 28-21008 N6853JMonte & Co LLC · Cedar Key, FLBuilt 1976 · S/N 28-7615376 N6854FWilson Stanton H · Vista, CAS/N 32R-7780038 N6854JTerwilliger John E · Hegins, PABuilt 1976 · S/N 28-7690410 N6854WKimberl John M · Milton, FLBuilt 1965 · S/N 28-21010 N6855JLord Robert B Trustee · Lamar, COBuilt 1976 · S/N 28-7690411 N6855XHartsock William Kent · Morristown, TNBuilt 1968 · S/N 28-4642 N6856FSchuybroek Aviation Inc · Dover, DEBuilt 1976 · S/N 32R-7780040 N6856JWancho Brian J · El Paso, TXS/N 28-7690412 N6856WRogers Kevin Shane · Highland Village, TXBuilt 1965 · S/N 28-21012

Back to AD 87-08-08 R3