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.

N6930WFlat Out Aviation LLC · Mercer, MOS/N 28-21105 N6931JMissouri Valley Flying Club Inc · Culbertson, MTBuilt 1976 · S/N 28-7690433 N6932FBruns Luke J · Flower Mound, TXBuilt 1976 · S/N 28-7790174 N6932JRamonetta Vince · Westbrook, CTS/N 28R-7635362 N6933WAlpha 1 Aviation LLC · Helena, ALBuilt 1965 · S/N 28-21110 N6934JCopaair Maintenance Services Inc · Indiantown, FLBuilt 1976 · S/N 32R-7680389 N6934WBenal Charles A · Hastings, NEBuilt 1965 · S/N 28-21111 N6936WBergstrom Lindsay B · Plymouth, MNBuilt 1965 · S/N 28-21114 N6938JBerry Joe O · Franklin, TNBuilt 1977 · S/N 28-7716001 N6939WCherokee Eaglefang LLC · New Braunfels, TXBuilt 1965 · S/N 28-21119 N693FLBallauer Walter · Remus, MIBuilt 1971 · S/N 28-7125631 N693HAHawkins Flight Academy LLC · Shelbyville, TNBuilt 1968 · S/N 28-24178 N693LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881218 N693UTLongone Nicholas F · Hollywood, FLBuilt 1978 · S/N 32R7885137 N6940FRebel Ranch LLC · Glenwood, ARBuilt 1976 · S/N 32R-7780050 N6940JReisch Michael L · Carlisle, MABuilt 1976 · S/N 28-7615404 N6941JPalmenteri Louis J · Rhome, TXS/N 28-7615405 N6942JAndromeda Air LLC · Houston, TXBuilt 1976 · S/N 28-7690434 N6942WBobbe Debra M · Paradise Valley, AZBuilt 1965 · S/N 28-21122 N6944CUpdraft Leasing LLC · Tea, SDBuilt 1978 · S/N 28-7816442 N6944JJhap LLC · Hubbard, OHBuilt 1976 · S/N 28R-7635364 N6945JK&B Properties LLC · Lexington, SCBuilt 1976 · S/N 32R-7680391 N6948C48 Charlie LLC · Columbia, MDS/N 28R-7837177 N6948WCraig Joshua G · Bonaire, GABuilt 1965 · S/N 28-21134 N6949WSa Fliers LLC · Venice, FLBuilt 1965 · S/N 28-21138 N694ACNaiman Harold E · Denver, COS/N 28R-7931166 N694DBHammond Flying Club Inc · Covington, LABuilt 1975 · S/N 32-7540087 N694LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881219 N694PCBajedi Aviation LLC · Lewes, DEBuilt 2002 · S/N 3257305 N694RMTavel Charles · Cave Creek, AZBuilt 2005 · S/N 2843607 N6950WEalp LLC · Evansville, INBuilt 1965 · S/N 28-21140 N6952CSnoz Inc · Sharon, MABuilt 1978 · S/N 28R-7837178 N6952JLagimoniere Gregory · Jacksonville Beach, FLBuilt 1976 · S/N 28R-7635365 N6952WBeaver Milton H II · Palmer, AKBuilt 1965 · S/N 28-21143 N6953JDubois Marcus S · Olive Branch, MSBuilt 1976 · S/N 32R-7680393 N6953WScotting David R · Pipestone, MNBuilt 1965 · S/N 28-21144 N6954JHughston Thomas Price · NorfolkBuilt 1976 · S/N 32R-7680394 N6956JJuliet Sky LLC · Sioux City, IABuilt 1976 · S/N 28-7690439 N6958JAkin Enterprises Inc · Greensboro, GABuilt 1976 · S/N 28-7690441 N6958WPeck Michael S · Las Vegas, NVBuilt 1965 · S/N 28-21150 N695APiper Archer Three LLC · Wilmington, DEBuilt 2014 · S/N 2843782 N695DTRegistered aircraftBuilt 1995 · S/N 3213102 N695FParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020237 N695FLPugh Daniel J · Omaha, NEBuilt 1971 · S/N 28-7125634 N695LHJrnd Corp · Lewes, DEBuilt 2023 · S/N 2881628 N695RDWerhanowicz Michael K · Hemet, CABuilt 1972 · S/N 28-7310001 N6960JMichiana Air Activities Inc · Osceola, INBuilt 1976 · S/N 32-7640106 N6961JBaja Airventures Inc · Chula Vista, CABuilt 1976 · S/N 32R-7680395 N6961WExpresstek LLC · Farmington, UTBuilt 1965 · S/N 28-21155 N6962JBores Scott J · Huron, OHBuilt 1976 · S/N 28-7625262

Back to AD 87-08-08 R3