Skip to content

Registered aircraft · 8,139

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:96-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:96-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:96-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:96-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:96-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:96-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.

N8713COlsen Crosby J · Bainbridge Island, WABuilt 1976 · S/N 28-7625127 N8714NHatch Joseph B · Mesa, AZBuilt 1969 · S/N 28-25615 N8715NKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1969 · S/N 28-25617 N8716NWeiss Ariel · Bisbee, AZBuilt 1969 · S/N 28-25618 N8718NKelly Bradford S · Bedford, NHBuilt 1969 · S/N 28-25623 N8720NHogan David A · La Crosse, WIBuilt 1969 · S/N 28-25532 N8721NCobe Aviation LLC · Miller, SDBuilt 1969 · S/N 28-25533 N8722NKrueger Sandra J · Chicago, ILBuilt 1969 · S/N 28-25534 N8723ECronk Howard J · Council Bluffs, IABuilt 1976 · S/N 28-7625150 N8724NSea 2 Sea LLC · Cantonment, FLBuilt 1969 · S/N 28-25537 N87269Clint Aaron Aviation LLC · Columbus, GABuilt 1976 · S/N 287725067 N8727FVancura Aviation LLC · Seffner, FLBuilt 1976 · S/N 28-7725124 N8727NMelder Brandon W · Alexandria, LABuilt 1969 · S/N 28-25540 N8729NCano Felix H · Fort Worth, TXBuilt 1969 · S/N 28-25544 N872MAFalligant Robert E · Savannah, GABuilt 1968 · S/N 28-24611 N8734NLowe Brian D · Prescott, KSBuilt 1969 · S/N 28-25549 N8735NManzanares Jason J · Albuquerque, NMBuilt 1969 · S/N 28-25550 N8737ECarleton Scott A · Van Nuys, CABuilt 1976 · S/N 28-7625152 N8737NWatkins Michael · Oak Harbor, WABuilt 1969 · S/N 28-25553 N8738NCf & Cb Inc · Atlantic Beach, FLBuilt 1969 · S/N 28-25356 N8740NNorth Vanessa C · San Luis Obispo, CABuilt 1969 · S/N 28-25555 N8741NBarber Jeffrey B Trustee · Sparks, NVBuilt 1969 · S/N 28-25556 N8743NRegistered aircraftBuilt 1969 · S/N 28-25559 N8744NTsuei Mark · San Mateo, CAFirst renewal noticeBuilt 1969 · S/N 28-25558 N8746NByard Jeffery G · Carson City, NVBuilt 1969 · S/N 28-25562 N8747EBarbrie Nicholas J · Pittston, PABuilt 1976 · S/N 28-7625153 N8749NPowell Randell W · Wachapreague, VABuilt 1969 · S/N 28-25569 N8750NMidwest Avionics LLC · Peculiar, MOBuilt 1969 · S/N 28-25570 N8753NWright Pamela J · Easton, PABuilt 1969 · S/N 28-25573 N8754ESix Two Seven Aviation LLC · Sardis, MSBuilt 1976 · S/N 28-7625155 N8757N57 November LLC · Charlotte, NCBuilt 1969 · S/N 28-25576 N8759NDisanto Rocco F · Morganton, NCBuilt 1969 · S/N 28-25580 N8762EPrewitt Russell · Statham, GABuilt 1976 · S/N 28-7625156 N8762NKlyc Aviation LLC · Lake City, FLBuilt 1969 · S/N 28-25582 N8763NNardi Rocky · Floyds Knobs, INBuilt 1969 · S/N 28-25585 N8767NAbernathy Larry D · Vernon, TXBuilt 1969 · S/N 28-25591 N8768NHammonds Benjamin J · Newcomerstown, OHS/N 28-25589 N8773NBeen Flyin LLC · Colchester, CTBuilt 1969 · S/N 28-25597 N8775NPerez Jeremiah · Fort Worth, TXBuilt 1969 · S/N 28-25599 N8777NDaniel Adam Christopher · Sanford, NCBuilt 1969 · S/N 28-25601 N8779NNorth Little Rock Air Inc · North Little Rock, ARBuilt 1969 · S/N 28-25604 N877DAWest Prairie Aircraft LLC · Weiner, ARBuilt 1969 · S/N 28-25877 N877MAMason Rory L · Auburn, NEBuilt 1966 · S/N 28-3674 N8783NGustafson Randolph W · Wisconsin Rapids, WIBuilt 1969 · S/N 28-25616 N8784NBates James L · Reisterstown, MDBuilt 1969 · S/N 28-25621 N8785N85n Corp · Oak Hill, VABuilt 1969 · S/N 28-25622 N8786NSorenson Kyle F · Deaver, WYBuilt 1969 · S/N 28-25772 N878DA92nd West Aviation Inc · Lonoke, ARS/N 28-7125620 N8791NVetter Daniel W · Dayton, NVBuilt 1969 · S/N 28-25631 N8792NPiotrowski Nicholas S · Poplar Grove, ILBuilt 1969 · S/N 28-25633

Back to AD 96-10-01 R1