Skip to content

Registered aircraft · 26,232

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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.

N762DMMizak Dennis M · Adrian, MIBuilt 2024 · S/N 22724 N762MAGiovannetti Peter C · Fond Du Lac, WIBuilt 1966 · S/N 15065187 N762SGiddens Mike J · Novato, CABuilt 1991 · S/N 1691 N76303Lewis Nicholas · Stony Creek, VABuilt 1946 · S/N 10717 N76304Johnson John P A · Hayden Lake, IDBuilt 1946 · S/N 10718 N76310Poe David W · Crystal Lake, ILBuilt 1946 · S/N 10724 N76314Downey Gerard P · Boise, IDBuilt 1946 · S/N 10728 N7631XCiccosanti John P · Kingston, NYBuilt 1960 · S/N 17248131 N76324Hettmann Jeffrey J · De Pere, WIBuilt 1946 · S/N 10738 N76326Reiner William P · Anchorage, AKBuilt 1946 · S/N 10740 N7632XTrompeter Mark S · Intl Falls, MNBuilt 1960 · S/N 17248132 N76336Bostani Majo · Philadelphia, PABuilt 1946 · S/N 10753 N7633XHillis Robert Duane · Utopia, TXBuilt 1960 · S/N 17248133 N76340Monce Michael S · Granite City, ILBuilt 1946 · S/N 10757 N76344Jeffers Kyle A · New Carlisle, OHBuilt 1946 · S/N 10761 N7634MSutton Aircraft Salvage LLC · Palmer, AKBuilt 1959 · S/N 55934 N76351Cloudcruise Ventures LLC · Sacramento, CABuilt 1946 · S/N 10768 N76356Duisenberg Brian R · Santa Cruz, CAS/N 10773 N76358Dutchess Community College · Poughkeepsie, NYBuilt 1946 · S/N 10775 N76364Tedder Chase M · Harriman, TNBuilt 1946 · S/N 10781 N76366Trotter Virgil R · Asheboro, NCBuilt 1946 · S/N 10783 N76369Wilson Colin J · Farmers Branch, TXS/N 10786 N7636MPorter Bryan A · Deer Lodge, MTBuilt 1959 · S/N 55936 N7636TN7636t LLC · Farmdale, OHBuilt 1960 · S/N 47236 N76370International Air Services Inc Trustee · Carson City, NVBuilt 1946 · S/N 10787 N76371Hayward Billy · Hyannis, NEBuilt 1946 · S/N 10792 N76372Denelsky Logan · Medina, OHBuilt 1946 · S/N 10793 N76377Klutts Jerry · Rockwall, TXBuilt 1946 · S/N 10798 N76379Wiseth Devin · Fargo, NDBuilt 1946 · S/N 10800 N7637XReddy Investments LLC · Contoocook, NHS/N 17248137 N76380Mcdonald Jessica M · Prior Lake, MNBuilt 1946 · S/N 10801 N76381Leonard Timothy M · Tijeras, NMBuilt 1946 · S/N 10802 N76383Fischer Gregory Paul · Onekama, MIBuilt 1946 · S/N 10804 N76385Howard James Trustee · Cloudcroft, NMBuilt 1946 · S/N 10806 N7638MHerbert-Johnson Veronica L · Picayune, MSS/N 55938 N7638TEaglet Flight Operations Lp · Fort Worth, TXBuilt 1960 · S/N 47238 N7638XBreaux Matthew J · Grosse Tete, LAS/N 17248138 N76391Roughan Letricia F · Castaic, CABuilt 1946 · S/N 10812 N7639TCaldwell Perrin L · Batesville, MSBuilt 1960 · S/N 47239 N763PAComputer Services Inc · Yukon, OKBuilt 1974 · S/N 15075618 N76403Renco Angelo Julio · San Diego, CABuilt 1946 · S/N 10829 N76406Abbott Benjamin W · Morris, OKBuilt 1946 · S/N 10832 N7640TAloway Shaquetta S · Cleveland, OHS/N 47240 N7640XNotre Amour LLC · Cypress, TXBuilt 1960 · S/N 17248140 N76410Mccarthy Kiva A · Kodiak, AKBuilt 1946 · S/N 10836 N76413Registered aircraftBuilt 1946 · S/N 10839 N76415Sprinkle David C · Alameda, CABuilt 1946 · S/N 10841 N7641MCrawford Trevor Nicolas · Potter Valley, CABuilt 1959 · S/N 55941 N7641XEngelhardt David J · Williamsburg, OHBuilt 1960 · S/N 17248141 N76420Registered aircraftBuilt 1946 · S/N 10846

Back to AD 94-05-05 R1