Skip to content

Registered aircraft · 40,473

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

N737NGTactical Integrated Training Solutions LLC · San Antonio, TXBuilt 1977 · S/N 17269541 N737NJSutton Aircraft Salvage LLC · Palmer, AKBuilt 1977 · S/N 17269543 N737NLMoravan Gregory W · Portland, ORBuilt 1978 · S/N 17269545 N737NMCivil Air Patrol · Maxwell Afb, ALBuilt 1977 · S/N 17269515 N737NNSeyffert Charles M · Hampton, VABuilt 1977 · S/N 17269547 N737NRKenmore Air Harbor LLC · Kenmore, WABuilt 1977 · S/N 17269550 N737NUOracle Aviation LLC · Omaha, NEBuilt 1977 · S/N 17269553 N737NVMelbourne Flight Training LLC · Melbourne, FLBuilt 1977 · S/N 17269554 N737PCMurray Raymond R · Harriman, TNBuilt 1977 · S/N 17269560 N737PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1973 · S/N 34-7350171 N737PHPatriot Management Co Inc · Solvang, CABuilt 1977 · S/N 17269564 N737PJChawilder LLC · Chattanooga, TNS/N 17269565 N737PMSocal Aviation Inc · Chino, CABuilt 1977 · S/N 17269568 N737PPAir One Aviation LLC · Cedar City, UTBuilt 1977 · S/N 17269570 N737PRRoderick Kevin · Newport, RIBuilt 1977 · S/N 17269572 N737PVBattle Creek Powersports LLC · Jasper, TNBuilt 1977 · S/N 17269576 N737PWRegion Flyers LLC · Valparaiso, INBuilt 1977 · S/N 17269577 N737PYMy Way Aviation LLC · Weston, FLBuilt 1977 · S/N 17269579 N737PZFerguson Carrie L · Palo Alto, CABuilt 1977 · S/N 17269580 N737QCTwinco Flying Club Inc · Wappingers Falls, NYBuilt 1977 · S/N 17269583 N737QFWings Over L A Aviation LLC · West Hills, CAS/N 17269586 N737QLRegistration Pending · Calabasas, CARegistration pendingBuilt 1977 · S/N 17269591 N737QPStarlin Air LLC · Crawfordsville, INBuilt 1977 · S/N 17269594 N737QRClark Walter · Denver, NCBuilt 1977 · S/N 17269596 N737QXFirst Eclipse Ltd · Richmond, VABuilt 1977 · S/N 17269602 N737RMassad Sam I · Brunswick, GAS/N 17269386 N737RADodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N 17269605 N737RECroutch Marvin L · Encino, CABuilt 1977 · S/N 17269609 N737RGThomas Troy A · Hastings, NEBuilt 1977 · S/N 17269611 N737RLGeneral Aviation LLC · Henderson, NVBuilt 1977 · S/N 17269615 N737RNFife Aire LLC · Newnan, GABuilt 1977 · S/N 17269617 N737RPElevated Aviation LLC · North Charleston, SCBuilt 1977 · S/N 17269618 N737RQHughes Stephen E · Danbury, CTBuilt 1977 · S/N 17269619 N737RRMindy Limited LLC · Muscatine, IABuilt 1977 · S/N 17269620 N737RTFeather Worx Aviation LLC · Bonita Springs, FLBuilt 1977 · S/N 17269622 N737RVBalaska Mark A · Whitestown, INBuilt 1995 · S/N 737 N737RXBuckleitner Eric M · Gaylord, MIBuilt 1977 · S/N 17269626 N737SAN737sa LLC · Lantana, FLBuilt 1977 · S/N 17269629 N737SBCothren Graff Smoak Engineering Inc · Shreveport, LAS/N 17269630 N737SCIsely Alec D · Monroe, WIBuilt 1977 · S/N 17269631 N737SDBreidenthal Robert E · Seattle, WABuilt 1977 · S/N 17269632 N737SJOracle Aviation LLC · Omaha, NEBuilt 1977 · S/N 17269637 N737SRAbove The Haze LLC · San Lorenzo, CABuilt 1977 · S/N 17269644 N737SUSkypark Aviation LLC · Bountiful, UTBuilt 1977 · S/N 17269647 N737SVPage Flying Club Inc · Page, NDBuilt 1977 · S/N 17269648 N737SXRoudebush Kevin L · Salem, ORBuilt 1977 · S/N 17269649 N737SZPeres John Patrick · Portland, ORS/N 17269651 N737TCFlyboys Nevada LLC · Henderson, NVBuilt 1977 · S/N 17269654 N737TDJarvis Jeffrey S · Portland, ORBuilt 1977 · S/N 17269655 N737TEJohn P Kintzle LLC · Mount Prospect, ILBuilt 1977 · S/N 17269656

Back to AD 80-04-03 R2