Skip to content

Registered aircraft · 6,915

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:97-01-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:97-01-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:97-01-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:97-01-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:97-01-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:97-01-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.

N3543MConnor Michael B · Antioch, TNBuilt 1978 · S/N 28R-7803176 N354JHArrow Group 5 LLC · Lake Saint Louis, MOBuilt 1974 · S/N 28R-7435233 N354PCLund Vern E · Madera, CABuilt 1964 · S/N 24-3611 N3554MWacker Peter K · Marietta, GAS/N 28R-7837123 N3557YNoble Stewart G · Reno, NVBuilt 1966 · S/N 30-1078 N35597My Flight LLC · Cypress, TXS/N 34-8070063 N3559MMoyer Josiah E · Paradise, PABuilt 1978 · S/N 28R-7837124 N355AJTexas Flyers LLC · Amarillo, TXBuilt 1978 · S/N 28R-7803282 N355CTRegistration Pending · Eldersburg, MDRegistration pendingS/N 32R-7780486 N3560MBeyond Grateful LLC · Frisco, COBuilt 1978 · S/N 28R-7803177 N35611Schutte Farm Inc · Burlington, COS/N 28R-8031032 N3561XAereotronics Inc · Wilmington, DEBuilt 1980 · S/N 34-8070073 N35636Carreno Miriam · Portland, ORBuilt 1979 · S/N 28R-8031036 N3569QTerry Woodard Enterprises Inc · Beaumont, TXBuilt 1977 · S/N 28R-7703115 N3570BSoutheastern Logistics LLC · Blackshear, GAS/N 34-8070080 N35727Angel Aviation Inc · Peoria, AZS/N 348070084 N3577UHensley Bradley S · Lake Charles, LAS/N 34-8070100 N3585MHanlin Dale E · Porter, TXBuilt 1978 · S/N 28R-7837126 N3587MWellspring Air Group LLC · East Helena, MTBuilt 1978 · S/N 28R-7803179 N3588MCavu Aviation LLC · Draper, UTBuilt 1978 · S/N 28R-7803180 N3589MGregory Kenneth C · Gilbert, AZBuilt 1978 · S/N 28R-7803181 N359DWDurrell Lee W · Channel IslandsS/N 30-770 N35ADSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 30-1121 N35ARRaven Air LLC · Miami, FLFirst renewal noticeBuilt 1977 · S/N 347770254 N36024Walla Walla University · College Place, WABuilt 1978 · S/N 28R-7837262 N36049Koppenhaver Seth Tyson · Oro Valley, AZBuilt 1978 · S/N 34-7870287 N3605MIsland Bound LLC · Dunedin, FLBuilt 1978 · S/N 34-7870118 N36067Armor Corps Inc · Spring Hill, TNBuilt 1978 · S/N 28R-7803309 N36096Miami Arrow LLC · Peru, INBuilt 1978 · S/N 28R-7837265 N36097Conner Don R · Hot Springs, SDFirst renewal noticeS/N 28R-7803310 N3609QNorthern Aviation LLC · Palmer, AKBuilt 1977 · S/N 32R-7780319 N36106Leaseair LLC · Wilmington, DEBuilt 1978 · S/N 34-7870293 N36120United States Air Force Owner · Hanscom Afb, MABuilt 1978 · S/N 28R-7837266 N3612QFerrara Anthony · Warren, NJS/N 32R-7780320 N36282Beverly Flight Center LLC · Danvers, MABuilt 1978 · S/N 28R-7837271 N3630MAmercani Mahmoud · Fayetteville, GABuilt 1978 · S/N 28R-7803182 N3631MTrekjet LLC · Southington, CTBuilt 1978 · S/N 28R-7803183 N3632PAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1969 · S/N 24-3632 N36345Altair Aircraft LLC · Gainesville, FLBuilt 1978 · S/N 34-7870321 N36369Eastern Aeroworks LLC · Punxsutawney, PABuilt 1978 · S/N 34-7870323 N36371Akridge Jeffry J · Moses Lake, WAS/N 34-7870324 N36384Lisa Rocco J · Elkhart, INBuilt 1978 · S/N 28R-7837277 N36482Fair Air Inc · Bloomfield Hills, MIBuilt 1978 · S/N 34-7870335 N36487Steele Charles C · Hollandale, MSS/N 34-7870337 N36496Moseler Scott · Barrington, ILBuilt 1978 · S/N 28R-7803326 N36536Sky High Investments LLC · Greenwood, INBuilt 1978 · S/N 34-7870341 N36574California In Nice Inc · San Jose, CABuilt 1978 · S/N 28R-7837284 N36619Gipson Ronnie R · Carlisle, PABuilt 1978 · S/N 28R-7837286 N3661MAlpha Kilo Enterprises LLC · Helena, MTBuilt 1978 · S/N 28R-7837129 N3664MEchtle Keith A · Castroville, TXBuilt 1978 · S/N 28R-7803184

Back to AD 97-01-01 R1