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.

N54DLMorris Samuel A · Prineville, ORBuilt 1976 · S/N 28-7690213 N54KAPoint To Point Air LLC · Arlington, WABuilt 1978 · S/N 32-7840197 N54MTMay Rose Ellen · Hampshire, ILBuilt 1969 · S/N 28-25821 N54SSNinja Turtle LLC · Fuquay Varina, NCBuilt 1978 · S/N 32R-7885254 N54TXBail Air LLC · Port Saint Lucie, FLBuilt 1977 · S/N 28-7890151 N55005Butler Joseph E · Somers, CTBuilt 1973 · S/N 28R-7335167 N55007Av8 Inc · Westborough, MABuilt 1973 · S/N 28-7310106 N5500UJones Donald T · Barrigada, GUS/N 28-21209 N55010Royal Aviation Academy LLC · Sarasota, FLBuilt 1973 · S/N 28-7325303 N55018Stiver Roger M · Nashville, ARBuilt 1973 · S/N 28-7305291 N55019Berry Kirby T · Poolville, TXBuilt 1973 · S/N 28-7305292 N5501FWade Joshua Michael · Saline, MIS/N 28-24839 N5501WTailwinds Aviation LLC · Kokomo, INBuilt 1962 · S/N 28-587 N55021Robertson Alan L · Hastings, NEBuilt 1973 · S/N 28-7305294 N55023Charron William H · Burwell, NEBuilt 1973 · S/N 28R-7335168 N55028First Alarm Aviation LLC · Fosters, ALBuilt 1973 · S/N 28-7305295 N55029Chandler William John · North Palm Beach, FLBuilt 1973 · S/N 28-7305296 N5502WWest Kentucky Wings And Toons LLC · Benton, KYBuilt 1962 · S/N 28-589 N55030Reiner John G · Wakefield, MIBuilt 1973 · S/N 28R-7335171 N55031Monaghan Management Corp · Greenwood Village, COBuilt 1973 · S/N 28-7310108 N55032Jacks Dean E · Madison, INBuilt 1973 · S/N 28-7310109 N5503FN5503f Aircraft Holdings LLC · Orangeburg, SCBuilt 1968 · S/N 28-24842 N5503UFuller Christopher Jason · Destin, FLBuilt 1969 · S/N 28-26211 N55041Napier Clarence M · Mount Juliet, TNBuilt 1973 · S/N 28-7305297 N55042Rohrbaugh Mark A · Lenexa, KSBuilt 1973 · S/N 28-7305298 N55044Yale Aviation Inc · New Haven, CTBuilt 1973 · S/N 28-7305299 N55049Spanier Sherri Kay · Belleview, FLBuilt 1973 · S/N 28-7310111 N5504FWieselquist Kermit L · Westford, MABuilt 1968 · S/N 28-24843 N5504GRemoteguard Services LLC · Wildwood, MOS/N 28-8290068 N5504WTaylor Deric C · Seguin, TXBuilt 1962 · S/N 28-591 N55050Newman Jeffrey M · Pauline, SCBuilt 1973 · S/N 32-7340097 N55055Martan LLC · Kansas City, MOBuilt 1973 · S/N 28-7305301 N55057Smooth Air LLC · Churubusco, INBuilt 1973 · S/N 28-7305302 N55058Eggensberger Edmund G · Simpsonville, SCS/N 28R-7335174 N5505FSerafinowicz Ronald P · Gilbert, AZBuilt 1968 · S/N 28-24844 N5505UPaper Plane Aviation LLC · Avon Park, FLBuilt 1969 · S/N 28-26215 N5505WPerez Daniel E · Parsons, KSBuilt 1962 · S/N 28-592 N55064Western Skyways Inc · Montrose, COBuilt 1973 · S/N 28-7325317 N55066Premier Capital Enterprises LLC · Hurricane, UTS/N 28-7305303 N55069Tre Aviation Corp · Wilmington, DEBuilt 1973 · S/N 28R-7335177 N5506FShen Air II Inc · Mount Crawford, VAS/N 28-7790128 N5506JSoaring For Christ LLC · Big Lake, AKBuilt 1968 · S/N 32-1051 N5506UHumberto Moreno · Mulberry, FLBuilt 1969 · S/N 28-26214 N5506WMchatton Dret A · Redding, CABuilt 1962 · S/N 28-593 N55078Tiritilli Robert · Mission Viejo, CABuilt 1973 · S/N 28-7325320 N55080Keath Brian S · Kansas City, MOBuilt 1973 · S/N 28-7305305 N55087Fosso Christopher M · Glendale, AZBuilt 1973 · S/N 28-7305308 N55088Slipstream Aviation LLC · Calera, ALBuilt 1973 · S/N 28R-7335178 N55089Zitren Frederick J · El Cajon, CABuilt 1973 · S/N 32-7340100 N5508VDelaney John J · Cottonwood, CAS/N 28R-7703129

Back to AD 87-08-08 R3