Registered aircraft · 26,232

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:94-05-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') 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:94-05-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
  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:94-05-05-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
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.

N77564Camm Air LLC · Lake Village, ARBuilt 1946 · S/N 22048 N77566Schaefer Douglas Lee · Victoria, TXS/N 22055 N7756GDedalis Emory A · Colts Neck, NJBuilt 1973 · S/N 15074725 N7756UReid Wayne P Jr · Yucaipa, CAS/N 15077832 N7756XSkelton Air LLC · Lewiston, IDBuilt 1960 · S/N 17248256 N77574Scuderi Thomas J · Elizabeth, COBuilt 1946 · S/N 22066 N7757EIvanchenko Sergey · Phoenix, AZBuilt 1959 · S/N 17557 N7757THarris Seth · Ellensburg, WABuilt 1960 · S/N 47357 N7757UTruitt Seth L · Cynthiana, KYBuilt 1964 · S/N 17251757 N7758EShannon Jon M · Conroe, TXBuilt 1959 · S/N 17558 N7758TWorringer Richard G · Tower, MNBuilt 1960 · S/N 47358 N7758XHewitt Chad R · Vernonia, ORS/N 17248258 N77596Sauer Rodney · Carpio, NDBuilt 1946 · S/N 22087 N77599Elge Ronald E · Aurora, NEBuilt 1946 · S/N 22090 N7759TMartin Douglas A · Bartlett, ILBuilt 1960 · S/N 47359 N7759UButts Alex D · Douglassville, PABuilt 1964 · S/N 17251759 N7760CSosa Leonardo Correa Luna · Stillwater, MNS/N 20520 N7760UScott Timothy E · West Danville, VTBuilt 1964 · S/N 17251760 N7761FSullivan Randall G · Liberty, TXBuilt 1966 · S/N 15063861 N7762EPierce Roger V · Broken Arrow, OKBuilt 1959 · S/N 17562 N7762FCosta Air Service LLC · Painted Post, NYS/N 15063862 N7762TLisle Rachel C · New Enterprise, PABuilt 1960 · S/N 47362 N7762XRodriguez Bruno · Crestview, FLBuilt 1961 · S/N 17248262 N77634Buckaroo LLC · Senoia, GABuilt 1970 · S/N 1 N7763FRoss Joshua S · Homer, AKBuilt 1966 · S/N 15063863 N7763TWood Pro Ventures LLC · Justiceburg, TXBuilt 1960 · S/N 47363 N7763UMarshall Michael S · Lincoln, CABuilt 1976 · S/N 15077835 N7764FAbouhatab Majed · Houston, TXBuilt 1966 · S/N 15063864 N7764XMalcolm Ward A · Moorefield, WVBuilt 1960 · S/N 17248264 N7765EFuellner Sean L · Shelocta, PAS/N 17565 N7765FFilippone Chrristopher A · Ormond Beach, FLS/N 15063865 N7765TWhisman Marc K · Long Beach, CABuilt 1960 · S/N 47365 N7765UCentral Ohio Soaring Association Inc · Marion, OHBuilt 1976 · S/N 15077837 N7766DO'Connell Francis G Trustee · Coeur D Alene, IDBuilt 1957 · S/N 18-5945 N7766EArmitage Alexandra S · Nederland, COBuilt 1959 · S/N 17566 N7766FBuckman Bill · Lorenzo, TXBuilt 1966 · S/N 15063866 N7766TGourley Steven E · Unionville, MOBuilt 1960 · S/N 47366 N7767EBruce Matthew · Arlington, TXBuilt 1959 · S/N 17567 N7767FMorris Donald R · Murphysboro, ILS/N 15063867 N7767TVisscher Paul J · Madison, GABuilt 1960 · S/N 47367 N7767USkynet Aviation LLC · Cocoa Beach, FLS/N 15077838 N7768EYounger David B · Port Angeles, WABuilt 1959 · S/N 17568 N7768UFoothill Sport Aviation LLC · Cameron Park, CABuilt 1976 · S/N 15077839 N7769EFieldgrove Matt · Somerton, AZBuilt 1959 · S/N 17569 N7769TWhiskey Tango Foxtrot Aviation LLC · Bemidji, MNBuilt 1960 · S/N 47369 N776SASopwith Camel Flying Club LLC · Salt Lake City, UTBuilt 1976 · S/N 15077884 N77701Dates Alec E · Red Creek, NYBuilt 1946 · S/N 331 N77705Anderson Dennis R · Brush Prairie, WABuilt 1946 · S/N 336 N77707Funk Aeroplane Co · Basehor, KSBuilt 1946 · S/N 337 N77708Arizona Bravo Lima LLC · Phoenix, AZBuilt 1946 · S/N 338

Back to AD 94-05-05 R1