Skip to content

Registered aircraft · 17,027

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

N2705QAdkins Emily L · Statesville, NCS/N 18257905 N2705SCarter James E · Thornville, OHBuilt 1967 · S/N 15066605 N2706SWings With The Word · Sanford, MEBuilt 1967 · S/N 15066606 N2706VBeuschel Timothy W · Mount Pleasant, WIBuilt 1975 · S/N 177RG0666 N2707FMontgomery Robert · Casper, WYS/N 18256807 N2708LRafter Jm Enterprises LLC · Swink, OKBuilt 1967 · S/N 17255908 N2708QElkhorn Aviation Inc DBA · Baker City, ORBuilt 1967 · S/N 18257908 N2709FArmentrout Billy W · Thomasville, NCBuilt 1965 · S/N 18256809 N2709LGuideair LLC · Eden Prairie, MNBuilt 1967 · S/N 17255909 N2712QGrotbeck Carter L · Albuquerque, NMBuilt 1967 · S/N 18257912 N2712SKelly Matthew Raymond · New Florence, MOBuilt 1967 · S/N 15066612 N2713LFlemmer Richard W · Park City, MTBuilt 1967 · S/N 17255913 N2713QJeff Jones Aircraft Company LLC · Quincy, WABuilt 1967 · S/N 18257913 N2714FDdh LLC · Goddard, KSBuilt 1965 · S/N 18256814 N2715FLow Wings Aviation LLC · Gassville, ARBuilt 1965 · S/N 18256815 N2715LGoebel Christian E · Luray, VABuilt 1967 · S/N 17255915 N2716SWright Herbert L · Vickery, OHBuilt 1967 · S/N 15066616 N2717SMartin Tyler · Pompano Beach, FLBuilt 1967 · S/N 15066617 N2718FJackalope Flyers LLC · Whitefish, MTBuilt 1965 · S/N 18256818 N2718QJenerette Marcus · Galivants Ferry, SCBuilt 1967 · S/N 18257918 N2718SBurroughs David G · El Paso, ILBuilt 1967 · S/N 15066618 N2719FSjoblom Erik Anders · Washington Twp, MIBuilt 1966 · S/N 18256819 N2720LBaalman Gary E · San Jose, CABuilt 1967 · S/N 17255920 N2720QDelta Yankee Aviation LLC · Anguilla, MSBuilt 1967 · S/N 18257920 N2721QN2721q LLC · Stuart, FLBuilt 1967 · S/N 18257921 N2721SPeyton Investments LLC · Washington, NCS/N 15066621 N2722LSmolik Amanda · Northlake, TXBuilt 1967 · S/N 17255922 N2723FTrantham Robert Keith · Alexandria, ALBuilt 1966 · S/N 18256823 N2723LJkr7 LLC · The Dalles, ORBuilt 1967 · S/N 17255923 N2724FIsley Rocky · Lacey, WABuilt 1965 · S/N 18256824 N2725F85 Charlie Papa LLC · Phoenix, AZBuilt 1965 · S/N 18256825 N2725LFulenchek Raymond D · Sherman, TXS/N 17255925 N2726VTurpin Michael · Rcho Sta Marg, CABuilt 1975 · S/N 177RG0673 N2727QEstes Gregory T · Jonesville, VABuilt 1967 · S/N 18257927 N2727SMiller Colin B · Fargo, NDBuilt 1967 · S/N 15066627 N2727VFitzgerald Kevin C · College Station, TXS/N 177RG0674 N2728LPotter Mark H · Santa Rosa, CABuilt 1967 · S/N 17255928 N2729FSexton & Sanders Law Firm Pa · Fort Smith, ARBuilt 1965 · S/N 18256829 N2729QCraft Phyllis C · Damascus, GABuilt 1967 · S/N 18257929 N2729SDates Lauren C · Red Creek, NYBuilt 1967 · S/N 15066629 N2730QSkylane Corp · Pittston, PABuilt 1967 · S/N 18257930 N2731Q31q LLC · Boise, IDBuilt 1967 · S/N 18257931 N2732LGlenndale LLC · Jackson, MOBuilt 1967 · S/N 17255932 N2733FMetzger William M · Boonville, INBuilt 1965 · S/N 18256833 N2733LHugelman Frank J III · Waynesville, MOBuilt 1967 · S/N 17255933 N2733VOlson Kirk · Dickinson, NDBuilt 1975 · S/N 177RG0676 N2734FWard Christopher C · Lufkin, TXBuilt 1965 · S/N 18256834 N2734Q1175 Bangtail Way LLC · Greycliff, MTBuilt 1967 · S/N 18257934 N2735QRegistration Pending · Hearne, TXRegistration pendingBuilt 1967 · S/N 18257935 N2736LWilson Steven W · N Richlnd Hls, TXFirst renewal noticeBuilt 1967 · S/N 17255936

Back to AD 72-03-03 R3