Skip to content

AD 99-05-13 R1 WD

Registered aircraft · 13,518

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:99-05-13-R1-WD') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD') 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:99-05-13-R1-WD')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
  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:99-05-13-R1-WD')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
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.

N7936KTurbo Air Charter LLC · Boise, IDBuilt 1964 · S/N D-7428 N7936RCloud Surfing LLC · Missoula, MTBuilt 1969 · S/N D-8962 N7937DSalem David R · Overland Park, KSBuilt 1957 · S/N D-5214 N7937LCombs Jonathan R · Anchorage, AKS/N M-989 N7938DWithers Mark D · Carthage, MSS/N D-5201 N7938KShurbet Mark S · Floydada, TXBuilt 1964 · S/N D-7431 N7938MSanders David D · Alvin, TXBuilt 1966 · S/N TD-666 N793DVon Menchhofen Zachery · Leola, PABuilt 1952 · S/N D-3062 N793LMJohnson Roger C · Lake Havasu City, AZBuilt 1979 · S/N D-10300 N793SBBailey Ronald L Jr · Jacksonville, FLBuilt 1957 · S/N D-5393 N793YPark City Flight Training LLC · Merrill, WIBuilt 1979 · S/N M-2184 N7940LCoggeshall Jerry · Beavercreek, OHBuilt 1966 · S/N M-992 N7941DShultz John William III · Port Republic, MDBuilt 1957 · S/N D-5176 N7941RRegistered aircraftBuilt 1969 · S/N D-8958 N7942LSpitzer Jimmy J · Waxahachie, TXBuilt 1966 · S/N MA-119 N7943DPositiverate Of Nc LLC · Aberdeen, NCBuilt 1957 · S/N D-5215 N7943ROlivia Flying Service Inc · Olivia, MNBuilt 1969 · S/N D-8959 N7944KTaylor Aviation Of Seminole Ok LLC · Seminole, OKBuilt 1964 · S/N D-7449 N7945AVergauwen Charles B · Wichita Falls, TXBuilt 1954 · S/N D-3951 N7945KCarlson Phillip D · Napa, CABuilt 1964 · S/N D-7436 N7945LBertsch David L · Caldwell, IDBuilt 1966 · S/N MB-144 N7946KLindgren Erik M · Riverside, CABuilt 1964 · S/N D-7434 N7946MGriesinger William R Trustee · Colorado Springs, COBuilt 1966 · S/N D-8255 N7946RIron Will Trucking LLC · Lancaster, KYBuilt 1969 · S/N TE-704 N79484Garnreiter Michael Trustee · Scottsdale, AZBuilt 1943 · S/N 4917 N7948DGurnett Kelsey · Rockport, MAS/N D-5190 N7948RRucinski Edward A · Climax, NCBuilt 1969 · S/N TC-1231 N7949KKeithley Terrance · Las Vegas, NVBuilt 1965 · S/N D-7938 N794CBBeckwith Robert E · Torrance, CABuilt 1978 · S/N CE-794 N7950DMcmillan Tony E · Burnsville, NCBuilt 1957 · S/N D-5234 N7952DJensen William Craig · Brookshire, TXBuilt 1957 · S/N D-5246 N7952MCherry Winds Aviation LLC · Wilmington, DEBuilt 1966 · S/N TE-192 N7952RVictory Lane Aviation LLC · Concord, NCBuilt 1969 · S/N TE-706 N7954DEvanoff Christopher J · Portales, NMBuilt 1957 · S/N D-5224 N7954KHamill Britt · Louisville, MSBuilt 1964 · S/N D-7458 N7955RAirjohn LLC · Cheyenne, WYBuilt 1969 · S/N TC-1234 N7956MDream Flyers LLC · Wilmington, DEBuilt 1968 · S/N D-8823 N7957RCunniff Michael L · Belle Mead, NJS/N D-8989 N7958LLongleaf Aviators LLC · Enterprise, ALBuilt 1966 · S/N MA-139 N7958PHall Wendell W · Cheraw, SCBuilt 1976 · S/N CE-655 N7958RFarrow Richard · Godfrey, ILBuilt 1968 · S/N TE-692 N7959DMarkoff Daniel · Las Vegas, NVBuilt 1957 · S/N D-5299 N7959MMed Care Inc · Grand Island, NES/N TE-189 N795BTwo Motor Odor LLC · Paris, TXBuilt 1948 · S/N D-1807 N795DDudley Hugh G · Albion, NYBuilt 1952 · S/N D-3064 N795SBInternational Air Services Inc Trustee · Carson City, NVBuilt 1991 · S/N CE-1599 N795YAirria Holdings LLC · BerlinBuilt 1979 · S/N ME-231 N7960DLaw Lewis L · Moncks Corner, SCBuilt 1957 · S/N D-5207 N7961DSoare Sean C · Poplar Grove, ILBuilt 1957 · S/N D-5229 N7962LMeisser Loren M · Marina, CAFirst renewal noticeBuilt 1966 · S/N M-998

Back to AD 99-05-13 R1 WD