Skip to content

Registered aircraft · 40,394

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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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.

N80279Tueller John D · Spring Creek, NVBuilt 1975 · S/N 17266492 N8027FCyganski David · Palm Beach Gardens, FLBuilt 1976 · S/N 28-7715255 N80282Nguyen Nhu-An T · Bethesda, MDBuilt 1975 · S/N 17266493 N80283Barxbar Aviation LLC · Mesa, AZBuilt 1975 · S/N 17266494 N80287Campbell Frederick G · Rigby, IDS/N 22902 N80291Davidson Doug W · Newcastle, WABuilt 1975 · S/N 17266500 N80295Legacy Skies Aviation LLC · Rogers, ARBuilt 1975 · S/N 17266502 N80298N80298 LLC · Miami, FLBuilt 1975 · S/N 17266504 N80299Mountain Air Aviation Inc · Bethesda, MDBuilt 1975 · S/N 17266505 N8029NHeydenreich Jacob N · Hartford, ARBuilt 1968 · S/N 28-25274 N8029PLong Trevor J · Flower Mound, TXS/N 24-3275 N802CMN802cm LLC · Lebanon, MOBuilt 2002 · S/N 2843541 N802FSShelton Shannon · Hampton, GABuilt 1971 · S/N 28-7125398 N802PWFlying Mermaid LLC · Aiea, HIBuilt 1981 · S/N 17275194 N802RGGandt Robert · Port Orange, FLBuilt 2003 · S/N 70215 N802RHKnl Associates LLC · Mansfield, OHBuilt 2017 · S/N 74366 N802UMLawrence Dayle A · Scotia, CABuilt 1972 · S/N 28-7225524 N802WHMansfield Heliflight · Milton, VTS/N 0802 N80304Matthews David A · Anchor Point, AKBuilt 1975 · S/N 17266510 N80307Hughes Fredrick A · Oklahoma City, OKBuilt 1975 · S/N 17266511 N8030DSunrise 6500 Inc · Wilmington, DEBuilt 2004 · S/N 22660 N8030NWilson Mark A · Havana, FLBuilt 1968 · S/N 28-25275 N8030WGosse Luke J · Waterloo, IABuilt 1964 · S/N 28-2096 N8031WGraziano Michael A · Freeport, NYBuilt 1965 · S/N 28-2097 N80322Mt Aviation LLC · Fairbanks, AKS/N 17266518 N80326Fly Lugu LLC · Southwick, MABuilt 1975 · S/N 17266520 N80327Highland Rim Aviation LLC · Springfield, TNBuilt 1975 · S/N 17266521 N8032CAirwego LLC · Wilmington, DEBuilt 1975 · S/N 28-7690097 N80331Johnson Shem E · Bonners Ferry, IDS/N 17266525 N80332Lamb Joseph M · Conway, ARBuilt 1975 · S/N 17266526 N80333Coeytaux Britton Marielle G · St Helena, CABuilt 1975 · S/N 17266527 N80335Rawareo LLC · Warsaw, MOBuilt 1975 · S/N 17266529 N80336Joyal Alfred N III · Marquette, MIBuilt 1975 · S/N 17266530 N80338Maldonado Monell Julio · Carolina, PRBuilt 1976 · S/N 17266532 N8033DLevinson Alan J · Delta Junction, AKBuilt 1957 · S/N 22-5558 N80340Tangojuliet Aviation LLC · La Porte, INBuilt 1976 · S/N 17266534 N80342Spanaflight LLC · Puyallup, WABuilt 1976 · S/N 17266535 N80347Aero Maintenance Inc · Vancouver, WABuilt 1976 · S/N 17266538 N8034DMyers Mark · Clovis, NMBuilt 1957 · S/N 22-5559 N8034EHill Matthew E · Abingdon, VABuilt 1975 · S/N AA5B0191 N8034WFieldgrove Kevin · Monroe, GABuilt 1965 · S/N 28-2101 N80350Lobstein Michael R · Belleville, ILBuilt 1976 · S/N 17266541 N80358Holmes Howard W · Lebanon, TNBuilt 1976 · S/N 17266547 N8035DSchulz Garth · Anchorage, AKBuilt 1957 · S/N 22-5560 N80363Corey Cathy Pike · Shelbyville, KYBuilt 1976 · S/N 17266551 N80366Steranka Paul O Jr · Charleston, WVBuilt 1976 · S/N 17266553 N80368Pray Aviation Inc · Augusta, KSBuilt 1981 · S/N 28-8216085 N8036LMonte Michael L · Palacios, TXS/N 1001 N80371N80371 LLC · Lovell, WYBuilt 1976 · S/N 17266555 N80372Nelson Bruce · Lutz, FLBuilt 1976 · S/N 17266556

Back to AD 79-10-03 R2