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.

N9721JSf Health Solutions Inc · Homestead, FLBuilt 1967 · S/N 28-3913 N9721KJet Time Consulting LLC · Gilbert, AZBuilt 1976 · S/N 28-7690277 N9721WCarson Bradley · Shippensburg, PAS/N 28-23199 N9722CRobbins Joseph R · Madison, ALBuilt 1978 · S/N 28R-7837219 N9722JRegistration Pending · Missoula, MTRegistration pending, pending cancellationBuilt 1967 · S/N 28-3914 N9723JRegistered aircraftBuilt 1967 · S/N 28-3915 N9724CGlobal Capital Partners LLC · Tualatin, ORBuilt 1978 · S/N 28R-7803276 N9724KGoodwin Thomas R · Martinsville, INBuilt 1976 · S/N 28-7690278 N9725CPowell Mark · Grandville, MIBuilt 1978 · S/N 32-7840114 N9725JSturgeon Aviation LLC · Ellijay, GABuilt 1967 · S/N 28-3917 N9726WSarratt Curtis H · Annapolis, MDBuilt 1967 · S/N 28-23204 N9727JJdc Aviation LLC · Upland, CABuilt 1967 · S/N 28-3920 N9727WGrinter Mark R · Highland, ILS/N 28-23205 N9729CEffingham Eta LLC · Effingham, ILBuilt 1978 · S/N 32-7840115 N9729WArtesian Hills Aviation LLC · Twin Lake, MIBuilt 1967 · S/N 28-23207 N972CPlainfield Aviation Inc · Plainfield, ILBuilt 2002 · S/N 2843538 N972CAKleinschnittger Steven J · Alton, ILBuilt 1966 · S/N 28-3209 N972LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 2844172 N972MWKo Hee Sun · Norwood, NJBuilt 1999 · S/N 2844019 N972QJInvictus Health LLC · Yorktown, VAFirst renewal noticeBuilt 1978 · S/N 28R7803366 N972TFAir Fleet Holdings LLC · Missoula, MTS/N 2881595 N9731WDacy David M · Harvard, ILBuilt 1967 · S/N 28-23210 N9732JWalborn Gary D · Youngstown, OHBuilt 1967 · S/N 28-3925 N9732WFlying Elvis · Jacksonville, FLBuilt 1967 · S/N 28-23212 N9733WWilson Lyndon K Sr · Ringgold, GAS/N 28-23214 N9734JPiper Perfect LLC · Panama City, FLBuilt 1967 · S/N 28-3927 N9734WNimbus Air LLC · Frankfort, ILS/N 28-23215 N9737WAzzurra City Tours LLC · Staten Island, NYBuilt 1967 · S/N 28-23219 N9738WBendigo Paul L · Reading, PABuilt 1967 · S/N 28-23220 N9739JSullins Drew Preston · Woodstock, MDBuilt 1967 · S/N 28-3933 N973CPTarpon Air LLC · St Pete Beach, FLBuilt 2005 · S/N 3255030 N973LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 2844173 N973SFInternational Air Services Inc Trustee · Carson City, NVS/N 32-7940074 N973TMAnders Andrew C · Lansdale, PABuilt 1972 · S/N 28-7205254 N9740JSpasiano Kyle P · Camarillo, CABuilt 1967 · S/N 28-3934 N9740WD14 Flight Club Inc · Manteno, ILBuilt 1967 · S/N 28-23222 N9741JSchulte Lance D · East Dundee, ILBuilt 1967 · S/N 28-3936 N9742JBores Scott J · Huron, OHS/N 28-3937 N9742WThurmond Donald · Madison, GAS/N 28-23224 N9743JMcmurry Patric R · Casper, WYBuilt 1967 · S/N 28-3939 N9743WFoster Jay W · Marshfield, MOBuilt 1967 · S/N 28-23225 N9744JMerrick Christina L · Sylmar, CABuilt 1967 · S/N 28-3940 N9745CWashington State Community College District 17 · Spokane, WABuilt 1978 · S/N 28-7816523 N9745JLakeview Aviation LLC · Great Barrington, MABuilt 1967 · S/N 28-3941 N9745WMadi Mohammed Nashat Ibrahim · Charlotte, NCBuilt 1967 · S/N 28-23227 N9746JJet Air Inc · Iowa City, IABuilt 1967 · S/N 28-3942 N9746WRegistered aircraftBuilt 1967 · S/N 28-23229 N9747JThomas Daniel S · Willow, AKBuilt 1967 · S/N 28-3943 N9747WAustin Christopher W · Dayton, NVBuilt 1967 · S/N 28-23230 N9748JReynolds John J · Howell, MIBuilt 1967 · S/N 28-3946

Back to AD 87-08-08 R3