Skip to content

Registered aircraft · 26,231

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.

N3770JAzad Raja M · Hawthorne, CABuilt 1966 · S/N 15065070 N3770LJ&C Aviation LLC · South Boston, VABuilt 1965 · S/N 17253939 N3770RBowery Michael P · Quinton, VABuilt 1966 · S/N 17255570 N37718Cole Rayce S · Palmer, AKS/N 46597 N3771JKozel Thomas · Pottstown, PABuilt 1966 · S/N 15065071 N3771LFlying Bs LLC · Midlothian, TXBuilt 1966 · S/N 17253940 N3771RMccay Brian D · Earlysville, VABuilt 1966 · S/N 17255571 N3771VRussell Steven D · Waxhaw, NCBuilt 1949 · S/N 15064 N3772Linstad Daniel E · Merlin, ORBuilt 1971 · S/N 2 N3772KSale Reported · Crestline, CASale reportedBuilt 1946 · S/N 1465 N3772RRiver Town Aviation LLC · Williamstown, WVBuilt 1966 · S/N 17255572 N3772SThree Strands LLC · Colorado Springs, COBuilt 1963 · S/N 17250972 N3773HDuvall Gene Adrian · Amarillo, TXBuilt 1947 · S/N 4398 N3773JBertrand Aviation LLC · Brookville, KSBuilt 1966 · S/N 15065073 N3773KHansen Ernest F · Sequim, WABuilt 1946 · S/N 1466 N3773PCan Am Capital · Lafayette, LABuilt 1955 · S/N 18-4659 N3773RBlair Richard J · Medina, OHS/N 17255573 N3773SFielden Donald J · Bartow, FLBuilt 1963 · S/N 17250973 N3774LKarr Stacy A · Hogansville, GABuilt 1965 · S/N 17253943 N3774TMcconnell Andrew D · Palmer, AKBuilt 1978 · S/N F-115 N3775LLee Michael Min · Dayton, OHBuilt 1965 · S/N 17253944 N3775VGevers David E · Lafayette, INBuilt 1949 · S/N 15068 N3776FRegistration Pending · Denver, NCRegistration pending, pending cancellationS/N 17255271 N3776LStramel Bert Jon · Colby, KSBuilt 1965 · S/N 17253945 N3776VCoach Masters Inc · Kearney, NES/N 15076619 N3776ZWelch Harold Dee · Phillips, WIBuilt 1960 · S/N 18-7457 N3777VOld School Aviation · Ottsville, PABuilt 1975 · S/N 15076620 N3778RSwede Aviation LLC · Tucson, AZBuilt 1966 · S/N 17255578 N3778VSmith Harold J · Poughkeepsie, NYBuilt 1975 · S/N 15076621 N3779FTiraphatna Jittakorn · Arlington, TXS/N 17255274 N3779SShawver Aviation LLC · Knoxville, IABuilt 1963 · S/N 17250979 N3779V212 Investments Of Montana LLC · Owasso, OKBuilt 1949 · S/N 15200 N377EPanepinto Lane P · Lafitte, LABuilt 1958 · S/N 17057 N377PZFrederick Sport Flyers Inc · Washington Grove, MDBuilt 2012 · S/N 6-6909 N377RMDinucci Gino · Clearwater, FLBuilt 1960 · S/N 56713 N3780FBoswell Cecil C · Columbus, MSBuilt 1966 · S/N 17255275 N3780LCropper Ryan Devon · Anchorage, AKBuilt 1965 · S/N 17253949 N37818Lovett Brett E · Liberty, MOBuilt 1941 · S/N 329 N3781FStoller Aircraft LLC · Sterling, OHBuilt 1966 · S/N 17255276 N3781JSantonocito John A · Bradenton, FLBuilt 1966 · S/N 15065081 N3781VHammitt Thomas K · Walnut Creek, CABuilt 1949 · S/N 15202 N3782Price Herman L · Azle, TXBuilt 1970 · S/N 67-24 N3782F82 Foxtrot LLC · Tucson, AZBuilt 1966 · S/N 17255277 N3782KRegistered aircraftBuilt 1946 · S/N 1475 N3782LAbraham Curtis L · Byron, WYBuilt 1965 · S/N 17253951 N3782PWillis Bernie W · Wasilla, AKBuilt 1955 · S/N 18-4675 N3782SBarnd Dennis Allen · Manchester, OHBuilt 1963 · S/N 17250982 N3782VRevlett Austin W · Sacramento, KYBuilt 1949 · S/N 15203 N3783KAndrews Nathan S · Graham, WABuilt 1946 · S/N 1474 N3783SBradley Electrical Plumbing & Heating LLC · Carson City, NVBuilt 1963 · S/N 17250983

Back to AD 94-05-05 R1