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.

N3635LRobinson Edgar M · Cairo, GABuilt 1965 · S/N 17253804 N3636LFllsend Aviation LLC · Kaysville, UTS/N 17253805 N3636UVandeman Jack P · Norco, CABuilt 1963 · S/N 18255036 N3638JEngelskirger Karl D · Valley City, OHBuilt 1966 · S/N 15064938 N3639JPrima County Community College · Tucson, AZBuilt 1966 · S/N 15064939 N3639LAzimuth Partners II LLC · Sanford, FLBuilt 1965 · S/N 17253808 N3639UWaltz Elizabeth · Grapevine, TXBuilt 1963 · S/N 18255039 N3640JCovington Brian · Florence, ALBuilt 1966 · S/N 15064940 N3640LHussain Mahmoud T · Miami, FLBuilt 1965 · S/N 17253809 N3640UMarkle Raymond J · Madawaska, MEBuilt 1963 · S/N 18255040 N3641LSeaplanes R Fun Inc · Wilmington, DEBuilt 1965 · S/N 17253810 N3642LMetro Technology Centers · Oklahoma City, OKBuilt 1965 · S/N 17253811 N3642UPm Barrett Aviation LLC · Tucson, AZBuilt 1963 · S/N 18255042 N3643UN3643u Aviation LLC · Denver, COBuilt 1963 · S/N 18255043 N3644JBoggs Dilan · Nicholls, GABuilt 1966 · S/N 15064944 N3644LHobbie Roy Lee · Cynthiana, KYBuilt 1965 · S/N 17253813 N3644ULawrence Carl E · Boulder, COBuilt 1963 · S/N 18255044 N3645LRegistered aircraftBuilt 1965 · S/N 17253814 N3645UHusaim John Steven · Hohenwald, TNBuilt 1963 · S/N 18255045 N3646JRegistration Pending · Cornelius, NCRegistration pending, pending cancellationBuilt 1966 · S/N 15064946 N3646LRobert Roger J · Gardner, MABuilt 1965 · S/N 17253815 N3646SCummings Larry D · Clarence, NYBuilt 1966 · S/N 17254827 N3646UGarner Lynn · Preston, IDS/N 18255046 N3647LEmmett Kerry N · Greeneville, TNBuilt 1965 · S/N 17253816 N3647UAdams Verne Franklin · Madera, CABuilt 1963 · S/N 18255047 N3648LGlenn William · Marion, NCBuilt 1965 · S/N 17253817 N3648UMerlin Aviation LLC · Grants Pass, ORBuilt 1963 · S/N 18255048 N3649LArmour Walton H · Alliance, OHBuilt 1965 · S/N 17253818 N3649USteele Aerospace Service LLC · Tulsa, OKS/N 18255049 N364CKSchneider William J Jr · Cedar Key, FLS/N 17260354 N364GSpruce Creek Consultants LLC · Port Orange, FLBuilt 1972 · S/N 17701776 N3650JPostle Jessica Grace · Newark, OHBuilt 1966 · S/N 15064950 N3650LTom Wrolstad Aircraft LLC · Molalla, ORBuilt 1965 · S/N 17253819 N3651UDeibel Adam · Flagstaff, AZS/N 18255051 N3652JJet Boy LLC · Carlsbad, CABuilt 1966 · S/N 15064952 N3652LJbm Aviation LLC · Mc Leansboro, ILBuilt 1965 · S/N 17253821 N3652SBennett Quinn S · Sterling, AKS/N 15062745 N3653JGrachev Timofey · Hammond, WIBuilt 1966 · S/N 15064953 N3653LRistau Kent T · Eagle Grove, IABuilt 1965 · S/N 17253822 N3653UMedeiros Germano Manuel · Caruthers, CABuilt 1963 · S/N 18255053 N3654LHeritage In Flight Museum Inc · Lincoln, ILBuilt 1965 · S/N 17253823 N3655UBoggs Dennis E · Buffalo, WYBuilt 1963 · S/N 18255055 N3656JLofland Aviaiton LLC · Moscow Mills, MOBuilt 1966 · S/N 15064956 N3656UMccarty Troy Allen · New Plymouth, IDBuilt 1963 · S/N 18255056 N3657LHollabaugh David S · Fulton, MOBuilt 1965 · S/N 17253826 N3658JBernbeck Alan R · Benton, KSBuilt 1966 · S/N 15064958 N3658LGraczyk Michael E · Lake Elmo, MNBuilt 1965 · S/N 17253827 N3659JHenderson Mark A · Duluth, GABuilt 1966 · S/N 15064959 N365RARanger Airfield Foundation · Ranger, TXBuilt 1972 · S/N 15073416 N3660LBersig James R · La Palma, CAS/N 17253829

Back to AD 72-03-03 R3