OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,639

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
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-01-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:99-01-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.

N4717MJake Air LLC · Lakeview, MIBuilt 1947 · S/N 11226N4719AAvquest Aviation Services LLC · Montgomery, NYBuilt 1956 · S/N 18-4939N4719MMaggart Kenneth R · Lutz, FLS/N 11-227N4719ZBergen Henry E · Fond Du Lac, WIS/N 228264N4720AP P & J LLC · Gillette, WYBuilt 1956 · S/N 18-4941N4720FBennett Ronald W · North Pole, AKBuilt 1963 · S/N 18-7989N4720HWiplinger Charles · Inver Grove, MNS/N 11-508N4720MHutton Mark B · Denison, TXBuilt 1947 · S/N 11-229N4721YHendrickson Flying Service Inc · Rochelle, ILBuilt 1967 · S/N 25-4463N4722AJoos Devon T · Menlo Park, CABuilt 1956 · S/N 18-4943N4722MMacdonald Kenneth A · Willow, AKBuilt 1947 · S/N 11-231N4722YX-C Soaring Association Inc · Pensacola, FLBuilt 1967 · S/N 25-4465N4723ZMartin William S · S Coffeyville, OKBuilt 1961 · S/N 22-8268N4724MHoudek Dennis E · Roseburg, ORBuilt 1947 · S/N 11-236N4725HIsland Air LLC · Eagan, MNBuilt 1948 · S/N 11-514N4725MCawley Clinton J · Carson City, NVS/N 11-237N4726NTaylor Micheal Patrick · East Olympia, WAS/N 7403N4726ZAyers Jeffrey L · Harveys Lake, PAS/N 22-8272N4727MLeland Edwin S · Yuba City, CABuilt 1947 · S/N 11-239N4727ZHartson William R · Petoskey, MIS/N 22-8273N4728HJensen Brian P · Eagan, MNBuilt 1948 · S/N 11-539N4729MTonys Aerial Spraying Inc · Great Bend, KSBuilt 1947 · S/N 11240N4729ZSublogic Corp · Urbana, ILBuilt 1961 · S/N 22-8275N4730MLovley Forrest T · Jordan, MNBuilt 1947 · S/N 11-242N4731MSmith James A · Lyle, WAS/N 11-244N4731ZLamb Steve E · Big Bear City, CAS/N 22-8278N4732HRuhnke Phil A · Grangeville, IDBuilt 1948 · S/N 11-548N4732YChilhowee Soaring Association Inc · Benton, TNS/N 25-4480N4734VShaw Logan · Redding, CABuilt 1950 · S/N 20-297N4735ZDebold David A · Spring, TXBuilt 1960 · S/N 22-8283N4736YHollatz Walter M · Concord, GABuilt 1967 · S/N 25-4488N4737ALohse Dennis A · Stevensville, MTBuilt 1956 · S/N 18-4962N4737HEgrass Gary S · Mcgrath, AKS/N 11-596N4737MConsalvi James V · Denver, COBuilt 1947 · S/N 11-249N4737ZLiljegren Frederick A · Parkers Prairie, MNBuilt 1961 · S/N 22-8288N4738ZSawl Security LLC · Rock Island, TNS/N 22-8289N4739MJones David E · Looneyville, WVS/N 11-251N4739ZMingus Paul H · Mesa, AZBuilt 1961 · S/N 22-8292N4740MTheobald Jesse L · Colstrip, MTBuilt 1947 · S/N 11-255N4741HMelin Jeff C · Kenmare, NDBuilt 1948 · S/N 11-600N4741MEkstrand Anders R · Palmer, AKBuilt 1947 · S/N 11-254N4742ZHudson James W · Granite City, ILS/N 22-8298N4743HJohnson Zachary M · Anchorage, AKBuilt 1948 · S/N 11-601N4744HMiller Jerold R · Deering, NDBuilt 1948 · S/N 11-603N4744ZGalloway Gordon · Knights Landing, CABuilt 1961 · S/N 22-8300N4745HTally Agribusiness Inc · Maryville, MOBuilt 1948 · S/N 11-604N4745MDorlac Patricia E · Windsor, COBuilt 1947 · S/N 11-263N4747ADouthitt Mike L · Butte, MTBuilt 1956 · S/N 22-3891N4748AWalker Nicole Ann · Angoon, AKBuilt 1956 · S/N 22-3892N4748YMemphis Soaring Society · Memphis, TNBuilt 1968 · S/N 25-4504
Back to AD 99-01-05 R1