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.

N7548JSnider Steve P · Anacortes, WABuilt 1968 · S/N 28R-30922 N7548WKaufold Richard · Ridge, NYBuilt 1963 · S/N 28-1481 N7549RHerring Josh G · Boston, GAFirst renewal noticeBuilt 1966 · S/N 28-22111 N7549WEarnest Matthew M · Norman, OKBuilt 1963 · S/N 28-1483 N754BWN Waller & Associates Inc · Mobile, ALBuilt 1999 · S/N 2843233 N754DM & M Aero LLC · Wilmington, DES/N 32-847 N754NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881033 N7550RMerrick David D · Rochester, INBuilt 1966 · S/N 28-22113 N7550WPebsworth Randal · Shallowater, TXBuilt 1963 · S/N 28-1485 N7551FBushwackers Leasing LLC · Calera, OKS/N 32R-7780062 N7551JKaercher Douglas A · Havre, MTBuilt 1968 · S/N 28R-30926 N7552WHeldt Jason R · Athens, WIBuilt 1963 · S/N 28-1487 N7553JThunder Arrow Corp · Santa Monica, CANon-citizen corporation, flight hours not reportedBuilt 1968 · S/N 28R-30929 N7553WGates Marshall D III · Pittsford, NYBuilt 1963 · S/N 28-1488 N7554WWiener Scott J · Santa Barbara, CABuilt 1963 · S/N 28-1493 N7555JKeller Terry · Sedona, AZBuilt 1968 · S/N 28R-30931 N7556JKern Aviation LLC · Shawnee, KSBuilt 1968 · S/N 28R-30933 N7556WSamuelson Dirk H · Orland Park, ILBuilt 1963 · S/N 28-1495 N7558RDodson Collin B · Weston, WVBuilt 1966 · S/N 28-22121 N7559JHale Edward L · Kingfisher, OKBuilt 1968 · S/N 28R-30937 N7559RPetersen Josh · Wasilla, AKBuilt 1966 · S/N 28-22122 N7559WOwens Alvin D · Malden, MOBuilt 1964 · S/N 28-1500 N755BEKilmartin Peter · Loudon, TNBuilt 1981 · S/N 32R-8213009 N755CABelieve It Two LLC · Sumter, SCBuilt 1996 · S/N 3246021 N755GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881206 N755NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881034 N755RKNorman Vick Construction Inc · Columbus, WIBuilt 1978 · S/N 32R-7887026 N755VSRosgen Kenneth-Ray C · Georgetown, TXS/N 32-7440039 N7560JRankin Kevin J · Maryville, MOBuilt 1968 · S/N 28R-30938 N7561WRay James L Jr · Meridianville, ALBuilt 1963 · S/N 28-1502 N7562JPrice Jesse L · Fargo, NDBuilt 1968 · S/N 28R-30940 N7562RDjm Investments Inc · Menno, SDBuilt 1966 · S/N 28-22126 N7563JKring Neal A · Ash Flat, ARBuilt 1968 · S/N 28R-30941 N7563RWright Barry C · Skidmore, MOBuilt 1966 · S/N 28-22127 N7564JElliott Gregg S · Eaton Rapids, MIS/N 28R-30942 N7565JSteffensen David J · Grimesland, NCBuilt 1968 · S/N 28R-30943 N7565RKnox County Flying Club · Owls Head, MES/N 28-22129 N7565WHurdle Scott R · Clemmons, NCBuilt 1963 · S/N 28-1506 N7566RHill Bruce W · Newton, ILBuilt 1966 · S/N 28-22130 N7566WStrobel Gary D · Mooresville, NCBuilt 1964 · S/N 28-1507 N7567JFidelis Universal Technology Inc · Chino Hills, CABuilt 1968 · S/N 28R-30946 N7567RThomas Baley B · Zavalla, TXFirst renewal noticeBuilt 1966 · S/N 28-22131 N7568JRoberts Donald B · Albion, ILBuilt 1968 · S/N 28R-30947 N756GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881462 N7570JHubbard David L · Earlville, ILS/N 28R-30950 N7570WWatkins Andrew B · Redding, CABuilt 1964 · S/N 28-1513 N7573RMonadnock Choppers LLC · North Swanzey, NHBuilt 1966 · S/N 28-22140 N7574JBayviators Flying Club · Mechanicsville, MDBuilt 1968 · S/N 28R-30963 N7574RWilliams Brian M · Lisbon, OHBuilt 1966 · S/N 28-22141 N7575JConsolidated Aviation Services LLC · Seymour, TNBuilt 1968 · S/N 28R-30964

Back to AD 87-08-08 R3