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.

N643MAPritchetts Point LLC · New Castle, INBuilt 2006 · S/N 3246243 N643MFRegistration Pending · Hanceville, ALRegistration pendingS/N 28020121 N643MTLaurel Fork Aviation LLC · Charlottesville, VABuilt 1969 · S/N 28-5646 N643PAYablonsky Richard R · Plymouth, MNBuilt 1979 · S/N 28R-7918218 N643TPMcconwell Edward A Sr · Mission, KSBuilt 1971 · S/N 28-7125176 N6440JGo Vertical Aviation LLC · Russellville, ALBuilt 1968 · S/N 28-4858 N6440RAir George LLC · Oblong, ILBuilt 1966 · S/N 28-21622 N6440WMckenney Robert N · Schertz, TXBuilt 1964 · S/N 28-20512 N6441JAnsell Nathan D · Mukwonago, WIBuilt 1968 · S/N 28-4859 N6442JDeberardinis Timothy P · Logandale, NVBuilt 1968 · S/N 28-4860 N6442RAmmozon LLC · Gilbert, AZS/N 28-21624 N6443JMcfarland Kenneth E · Kansas City, MOS/N 28-4861 N6443RTangen Christopher M · Pequot Lakes, MNBuilt 1966 · S/N 28-21625 N6444RSchool Board Of Nassau County Fl · Fernandina Beach, FLBuilt 1966 · S/N 28-21627 N6445RElmore Charles E · Flowery Branch, GABuilt 1966 · S/N 28-21628 N6446RChapin Lee · Newburgh, INFirst renewal noticeBuilt 1966 · S/N 28-21629 N6447JCasper Flair LLC · Wilmington, DEBuilt 1968 · S/N 28-4865 N6447RGensler Orion M · Bloomfield, MOBuilt 1966 · S/N 28-21630 N6447WSeverson Eric · Waukesha, WIBuilt 1964 · S/N 28-20519 N6448JMurphy Richard F · Hughesville, MDS/N 28-4867 N6448RShaw Timothy E · Ashtabula, OHBuilt 1966 · S/N 28-21631 N6448WSierra Lima Aviation LLC · Riverton, UTS/N 28-20520 N644BCRegistration Pending · Sioux Falls, SDRegistration pendingBuilt 1976 · S/N 32R-7680229 N644DFRegent Trust Corp Trustee · Wichita, KSBuilt 2023 · S/N 2881663 N644FLAty Aviation Inc · Watertown, SDBuilt 1971 · S/N 28-7125552 N644FTFlorida Institute Of Technology · Melbourne, FLBuilt 2013 · S/N 2843704 N644GRishel Keith D · Prineville, ORBuilt 1970 · S/N 28-26741 N6450JBurk Kevin M · Sunset, TXBuilt 1968 · S/N 28-4869 N6450RPlan Bee LLC · Washington, DCBuilt 1966 · S/N 28-21635 N6450WJones Bobby R · Colorado Springs, COBuilt 1964 · S/N 28-20522 N6451RDamian Richard E · Sioux Falls, SDBuilt 1966 · S/N 28-21636 N6451WHickman John N · Mohave Valley, AZBuilt 1964 · S/N 28-20523 N6452ROr-El Elbaz · Woodland Hills, CABuilt 1966 · S/N 28-21637 N6453JN6529r LLC · Manassas, VABuilt 1968 · S/N 28-4874 N6453RHerman Aaron T · Bryan, OHS/N 28-21638 N6453WN6453w LLC · Orlando, FLS/N 28-20526 N6454WSm Aviation LLC · Clermont, FLBuilt 1964 · S/N 28-20527 N6455JCartier Edward J Jr · Columbia, MSBuilt 1968 · S/N 28-4876 N6456JCherokee Dream Inc · Wilmington, DEBuilt 1968 · S/N 28-4877 N6456RCash Douglas Edward · San Antonio, TXBuilt 1966 · S/N 28-21642 N6457JHatcher Clifford J · Dallas, GABuilt 1968 · S/N 28-4878 N6457WWeston Keith M · Ogdensburg, NYBuilt 1964 · S/N 28-20530 N6458JFlorida Tectonics Inc · Weirsdale, FLBuilt 1968 · S/N 28-4880 N6458WJones Larry · Clovis, NMBuilt 1965 · S/N 28-20531 N6459RLogical Drive Inc · Siler City, NCBuilt 1966 · S/N 28-21645 N6459WBillingsley Littleton C Jr · Spicewood, TXBuilt 1964 · S/N 28-20532 N645AWHobart Aviation Inc · Akron, OHBuilt 1981 · S/N 28-8116305 N645BCNolan Kevin J · North Bend, ORBuilt 1974 · S/N 32-7540056 N645CHWebster Jason M · Orlando, FLBuilt 1972 · S/N 327240135 N645FLRule Charles Y · Mineral Point, WIBuilt 1971 · S/N 28-7125553

Back to AD 87-08-08 R3