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.

N3845RDelaney Patrick James · Marion, TXS/N 17255341 N3846KPrivitt Bret J · Forest Hill, TXBuilt 1948 · S/N 3546 N3846LElicker Sheldon L · Auburn, CABuilt 1966 · S/N 17254015 N3846RSampson Corey · Newnan, GABuilt 1966 · S/N 17255346 N3846VGreulich Kenneth R Trustee · Sand Springs, OKBuilt 1949 · S/N 18733 N3847JEscue James C · Brownsville, TNBuilt 1966 · S/N 15065147 N3847KMcdevitt Daniel C · Social Circle, GABuilt 1948 · S/N 3547 N3848LHarrod Group Inc · Ellaville, GABuilt 1966 · S/N 17254017 N3848RGunter Jeffrey W · Demorest, GAS/N 17255348 N3849JGamble Marty · Crofton, KYBuilt 1966 · S/N 15065149 N3849KSmith Jeffrey C · Asheboro, NCBuilt 1948 · S/N 3549 N3849RSims Charles H · Soldotna, AKBuilt 1966 · S/N 17255349 N3849VPaulas Daniel · Petaluma, CAS/N 18736 N38502Kraus Russell E · Albemarle, NCS/N 7071 N3850JDublin Charles · Wingo, KYBuilt 2010 · S/N 5 N3850RKelley Patrick W · Charlo, MTBuilt 1966 · S/N 17255350 N3850SFoss Sterling D · Basin, WYBuilt 1963 · S/N 17251050 N3850VFlorida Air Tours Inc · Merritt Island, FLBuilt 1949 · S/N 18737 N38511Lindemer Michael J · Seeley Lake, MTBuilt 1941 · S/N 7079 N3851VTexas Air Corps · Bullard, TXBuilt 1949 · S/N 18738 N3852HPaxton Ronald R · Colorado Springs, COBuilt 1947 · S/N 4553 N3852KBartholomew Don · Gardnerville, NVBuilt 1948 · S/N 3552 N3852LMountain Wings LLC · Salem, WVBuilt 1965 · S/N 17254021 N3852RChristman Mike G · Wasilla, AKBuilt 1966 · S/N 17255352 N3853Wetzel David F · Schuylkill Haven, PAS/N 6745 N38536Tavernaero Cub Club LLC · Tavernier, FLS/N 7121 N3854KHyland David N · Fall Creek, ORBuilt 1948 · S/N 3554 N3855JWiley Phillip W · New Martinsville, WVBuilt 1966 · S/N 15065155 N3855RAircraft Investment Group LLC · Cookeville, TNBuilt 1966 · S/N 17255355 N3855VKeiths Aviation Training LLC · Altus, OKS/N 18742 N3856JClifton Chad R · Asheboro, NCBuilt 1966 · S/N 15065156 N3856KSimply Living LLC · Fort Myers, FLBuilt 1948 · S/N 3556 N3856LSimmons Brandon M · Sylacauga, ALS/N 17254025 N3856RSmith Joseph M · Juneau, AKBuilt 1966 · S/N 17255356 N38579Vaughan Larry S · Amarillo, TXBuilt 1999 · S/N 5-997 N3857RLorring Eric Henry · Kodiak, AKBuilt 1966 · S/N 17255357 N3857VSrv Air Service LLC · Stockton, NJBuilt 1949 · S/N 18744 N3858SDearman Daniel R Sr · Cottonwood, CABuilt 1963 · S/N 17251058 N3858VMission Aviation LLC · Orange Park, FLBuilt 1975 · S/N 15076637 N3859JOnefiftyjuliet LLC · Saint Petersburg, FLBuilt 1966 · S/N 15065159 N3859LBourke Michael T · Adams, WIBuilt 1965 · S/N 17254028 N3859RLeja Dennis A · Watertown, WIBuilt 1966 · S/N 17255359 N3859VK3 Safe Air LLC · Mokena, ILBuilt 1975 · S/N 15076638 N385CHL H Aviation LLC · Clanton, ALBuilt 1966 · S/N 17255354 N385RPKnights Andrew J · Oklahoma City, OKBuilt 2012 · S/N REP-2 N3860KWind And Wheels LLC · Itasca, ILBuilt 1948 · S/N 3560 N3860LLake Area Technical College · Watertown, SDBuilt 1965 · S/N 17254029 N38619Winter Gary L · Ocala, FLBuilt 1941 · S/N 7160 N3861LSeverson Marshall G · Anchorage, AKBuilt 1966 · S/N 17254030 N3861RShawn James Robert · Pattison, TXS/N 17255361

Back to AD 94-05-05 R1