Skip to content

Registered aircraft · 20,481

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N7276PSanders Daniel K · Cuba, NMBuilt 1999 · S/N 18280566 N7276QBrynelsen Charles R · North Oaks, MNBuilt 1999 · S/N 18280567 N7276VLegends Air Center LLC · Bentonville, ARBuilt 1999 · S/N 18280570 N7276ZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 20608043 N72771Jones Steve · Roach, MOBuilt 2000 · S/N 18280924 N72780Dean'S Flight Inc · Pembine, WIS/N 18280954 N7278EAlvarez Scott · Battle Ground, WABuilt 1959 · S/N 52278 N7278NPerry Christopher W · West Sacramento, CAFirst renewal noticeBuilt 1974 · S/N 18263065 N7278SEngineers Flying Club Inc · Bethany, OKBuilt 1999 · S/N 18280506 N7278WHeinichen Richard · Dripping Springs, TXBuilt 1999 · S/N 18280509 N7278XTwin City Cloud 7 Inc · Eden Prairie, MNBuilt 1999 · S/N 18280510 N72798Skylane 72798 LLC · Winston Salem, NCBuilt 2001 · S/N 18280946 N7279BBautista Mark S · Sonora, CAS/N 18280542 N7279EXtreme Divers West Inc · San Juan, PRS/N 52279 N7279WCj Aviation LLC · Freeport, MEFirst renewal noticeBuilt 1999 · S/N 18280544 N727CMoore Kelly M · Moscow, IDBuilt 1958 · S/N 51319 N727CGOwens Keith E · Wrightstown, NJBuilt 2000 · S/N 18280838 N727CPCivil Air Patrol · Montgomery, ALBuilt 2010 · S/N 18282255 N727DGMarsh David G · Bluffdale, UTBuilt 1955 · S/N 31710 N727DRRoss Trucking LLC · Goldendale, WAS/N U206-0556 N727FACorporate Services LLC · Baton Rouge, LAS/N 21059414 N727FKVan Schoonhoven Peter · Battle Ground, WABuilt 1967 · S/N 21058912 N727GLRheney John W III · Cameron, SCBuilt 1976 · S/N 18264939 N727LHHale John A · Ennis, MTBuilt 1965 · S/N P206-0085 N727LSScarsella Luciano S · Lafayette, LAS/N 18265755 N727NEDeeair Ltd · Dayton, OHBuilt 1979 · S/N U20605152 N727NSBarrett Kemberly · Woodway, TXBuilt 2006 · S/N 18281809 N727PBRegistration Pending · Farson, WYRegistration pendingBuilt 1973 · S/N 18262260 N727PCPb&J Holding LLC · Franktown, COBuilt 1979 · S/N 18267396 N727SGCarbaugh Nicholas · Seattle, WAS/N 30405 N727VTFeber David G · Los Gatos, CABuilt 1999 · S/N 18280488 N727WSRobey Sean C · Camden, NCFirst renewal noticeBuilt 1978 · S/N 21063140 N728United States Department Of Interior · Boise, IDBuilt 1985 · S/N U20606877 N7282LPennau Karl · Fond Du Lac, WIBuilt 1999 · S/N 18280517 N7282NWtm Consulting LLC · Williamsburg, VABuilt 1999 · S/N 18280519 N7283EKirstein Terence C · Gilbert, AZBuilt 1959 · S/N 52283 N7284EFoster Craig M · Chandler, AZBuilt 1959 · S/N 52284 N7284NMcbride Kelly · Show Low, AZBuilt 1974 · S/N 18263071 N7285EAtchley Mark · Anthony, NMBuilt 1959 · S/N 52285 N7285NSale Reported · Fish Haven, IDSale reported, canceledBuilt 1974 · S/N 18263072 N7285QEight Five Quebec Assoc LLC · Tucson, AZBuilt 1973 · S/N 18262056 N7286EThiede Robert E · Palmer, AKS/N 52286 N7288EGay C R · Eagle Creek, ORBuilt 1959 · S/N 52288 N7289EMidfield Aviation LLC · Caldwell, IDS/N 52289 N7289NCandle Lane LLC · Sherman, CTBuilt 1974 · S/N 18263076 N7289QStenstrom Steven M · Scottsdale, AZBuilt 1973 · S/N 18262057 N728EGGarner John · Springfield, MOBuilt 1977 · S/N 18265842 N728HVBig Bang Air LLC · Wichita, KSBuilt 2023 · S/N 18283223 N7290EDiaz Mark A DBA · Madera, CAS/N 52290 N7291EBryant Daniel R · Brookland, ARBuilt 1959 · S/N 52291

Back to AD 84-10-01 R1