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.

N2760SBond Doyle G · Walker, LABuilt 1967 · S/N 15066660 N2760VFinish Line - N2760v LLC · Edmond, OKS/N 177RG0686 N2761LMiller David L · Mineral City, OHBuilt 1967 · S/N 17255961 N2762FFreflite LLC · Wilmington, DEBuilt 1966 · S/N 18256862 N2762LRock Communications · Rock Hill, SCBuilt 1967 · S/N 17255962 N2763FSeawings LLC · Holualoa, HIBuilt 1965 · S/N 18256863 N2763LTrent David A · Davin, WVBuilt 1967 · S/N 17255963 N2763SMoore Park · Byron, GABuilt 1967 · S/N 15066663 N2764QLong Donald G Jr · Gaston, ORBuilt 1967 · S/N 18257964 N2764SBivens Jason D · Duncan, OKBuilt 1967 · S/N 15066664 N2765FStoup Lyndal K · Cordell, OKBuilt 1965 · S/N 18256865 N2766FBrach Raymond S · Henderson, NVBuilt 1966 · S/N 18256866 N2766QThree Airmigos LLC · New Port Richey, FLBuilt 1967 · S/N 18257966 N2766SJohnston Beryle Lee · Franklin, PABuilt 1967 · S/N 15066666 N2767LGay David B · Citronelle, ALBuilt 1967 · S/N 17255967 N2768LJoseph Gary L · Ludlow, VTBuilt 1967 · S/N 17255968 N2768SSibley Michael Neal · Kenai, AKBuilt 1971 · S/N 15066668 N2768VThree Spirit Ventures LLC · Wayne, PABuilt 1975 · S/N 177RG0691 N2769FMatthews George W · Hillsboro, OHBuilt 1965 · S/N 18256869 N2769LRedditt Brian W · Columbia Station, OHBuilt 1967 · S/N 17255969 N2769QPrecision Truck Equipment Inc · Lansing, ILBuilt 1967 · S/N 18257969 N2770FEmmons Jack E · Elizabeth City, NCBuilt 1965 · S/N 18256870 N2770SBirk Ronald G · Wellington, NVBuilt 1967 · S/N 15066670 N2771LP&N Corp · Marion, IABuilt 1967 · S/N 17255971 N2772LBell William E Jr · Summerville, SCBuilt 1967 · S/N 17255972 N2773FAdriatic Holdings LLC · Cheyenne, WYBuilt 1966 · S/N 18256873 N2773VBeale Air Force Base Aero Club · Beale Afb, CABuilt 1975 · S/N 177RG0694 N2774QRdj Brothers Trucking Inc · Bigfork, MTBuilt 1967 · S/N 18257974 N2774SPeterson Dennis · Cambridge, MNBuilt 1967 · S/N 15066674 N2775FJock Carl A Trustee · Roscommon, MIBuilt 1966 · S/N 18256875 N2775LKing Mons A · Paoli, PABuilt 1967 · S/N 17255975 N2775QRay Chris J · Ironside, ORBuilt 1967 · S/N 18257975 N2775SRichardson Arthur · Herald, CAS/N 15066675 N2776FBabovic Slobodan · Elm Grove, WIS/N 18256876 N2776LRd Aire LLC · Opelika, ALBuilt 1967 · S/N 17255976 N2777LHataway Gregory L · Kinston, ALBuilt 1967 · S/N 17255977 N2778FHuber George M · Bentonville, ARBuilt 1966 · S/N 18256878 N2778SStamper Brian L · Tucson, AZBuilt 1967 · S/N 15066678 N2779FSweatt D Wayne · Memphis, TXBuilt 1966 · S/N 18256879 N2779LResetar Douglas J · Pittsford, NYBuilt 1967 · S/N 17255979 N277JKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1968 · S/N 18259292 N277KLCoombs Johnnie · Blue Mountain, MSBuilt 1966 · S/N 15064869 N277RTGonzalez Edwin A · Scott Afb, ILBuilt 1968 · S/N 15070021 N27808St George Flight Academy LLC · St George, UTBuilt 1971 · S/N 17260023 N2780SNapolitano Frank D · Howell, MIBuilt 1967 · S/N 15066680 N2781QGibboney Phillip M · Roseville, CABuilt 1967 · S/N 18257981 N2781SGadberry Garth · Heath, TXBuilt 1967 · S/N 15066681 N2782FMansoori Ali S · Aurora, COBuilt 1965 · S/N 18256882 N2782LSouthern Seaplane Inc · Belle Chasse, LABuilt 1967 · S/N 17255982 N2782QBauer Aviation LLC · Reese, MIBuilt 1967 · S/N 18257982

Back to AD 72-03-03 R3