Skip to content

Registered aircraft · 2,552

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

N372JCompass Rose Services Inc · Powell Butte, ORBuilt 1966 · S/N 320D0114 N372NMShelter Michael R · Sandy Lake, PABuilt 1970 · S/N 310Q0115 N3731GMaxwell Truck & Equipment LLC · State College, PABuilt 1977 · S/N 310R0906 N373JCVon Allman Chris D · Dos Palos, CABuilt 1962 · S/N 310G0137 N3744GValiair Limited Co Trustee · Casper, WYBuilt 1977 · S/N 310R0909 N3747CS I Air Inc · Dover, DEBuilt 1975 · S/N 414-0818 N374TAVintage Aero Inc · Brandon, FLBuilt 1974 · S/N 310Q1105 N3752CMiller Robert G · Clear Lake, IAS/N 414-0819 N3758CDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N 414-0839 N37676Campbell & Associates Investment Properties LLC · Burleson, TXBuilt 1974 · S/N 421B0584 N377CEMetal Mistress Aviation LLC · Meadowview, VABuilt 1976 · S/N 310R0631 N3796CPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1974 · S/N 402B0803 N3796GSantos Aviation LLC · Chico, CABuilt 1977 · S/N 310R0914 N37JKSsr LLC · Incline Village, NVS/N 421B0934 N37MBresciani Martin · Guaynabo, PRS/N 421B0805 N3809XVoracek Michael G · Richardson, TXBuilt 1966 · S/N 310K-0209 N3812XJets And Props Corp · Reno, NVS/N 310K0212 N3813GOne Three Golf LLC · Cleghorn, IABuilt 1977 · S/N 310R0916 N3813XRegistered aircraftAssigned, pending cancellationS/N 310K0213 N3817XPeterson Randall J · Lake Havasu City, AZBuilt 1966 · S/N 310K0217 N3818XAcme Racing LLC · Overland Park, KSBuilt 1966 · S/N 310K0218 N3819XBoerne Flight Options LLC · Boerne, TXBuilt 1966 · S/N 310K0219 N3820XDwyhalo David W · Moorpark, CABuilt 1966 · S/N 310K0220 N3823XRegistration Pending · Logan, UTRegistration pendingBuilt 1966 · S/N 310K0223 N3828GChoice Aviation LLC · Hamilton, MTS/N 310R0923 N382MCShiver James B · Stanley, NMS/N 421B0452 N3835CPreferred Airparts LLC · Apple Creek, OHBuilt 1973 · S/N 310Q0671 N3838XHolzman Douglas S · Hood River, ORBuilt 1966 · S/N 310K0238 N3839XMigliaccio Vicki Trustee · Idabel, OKBuilt 1966 · S/N 310K0239 N3841XJ W Faherty Inc · Apple Valley, CABuilt 1966 · S/N 310K0241 N3844CMansfield Heliflight Inc · Milton, VTS/N 310R1238 N3845XHaas James D · Frisco, TXBuilt 1966 · S/N 310K0245 N384AMHaggard Haley G · Springer, OKS/N 421B0304 N385JBBeck Todd G · Clarkston, MIBuilt 1959 · S/N 35828 N388SPWeber Donald E · Saint David, AZS/N 340-0337 N38FE239 Lear LLC · Dover, DES/N 340-0096 N38LPN38lp LLC · Jacksonville, FLBuilt 1977 · S/N 414-0960 N391ERegistration Pending · Dodge City, KSRegistration pendingBuilt 1960 · S/N 39131 N398PGeorge Monte C · Ashland, ORBuilt 1966 · S/N 320D0106 N3995AMccoy Keith · Salt Rock, WVBuilt 1978 · S/N 310R1347 N3999SViking Aviation LLC · Kindred, NDBuilt 1978 · S/N 310R1292 N39BTMidwest Aerial Photography · Galloway, OHBuilt 1974 · S/N 310Q1137 N39DDLarson Danny O · Palmer, AKBuilt 1973 · S/N 340-0246 N39HCTherapy Air LLC · Midland, TXS/N 414-0469 N3DQCrescent Aviation LLC · Rllng Hls Est, CAFirst renewal noticeBuilt 1970 · S/N 414-0056 N3HKInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 340-0538 N3HNDraper Floyd Lawrence · El Paso, TXBuilt 1967 · S/N 310L-0166 N3KXMarathon California Holdings Lp · San Diego, CABuilt 1971 · S/N 414-0161 N3LNAllen Jeffrey W · Crestwood, KYBuilt 1973 · S/N 340-0301 N3PKJohnson Marlon · Los Angeles, CABuilt 1956 · S/N 35390

Back to AD 76-08-02 R2