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.

N321JTPcss Aviation LLC · New Albany, MSBuilt 2001 · S/N EA-670 N321MJPetrie David W · Mechanicville, NYBuilt 1976 · S/N M-1850 N321NOatman Scott A · Colorado Springs, COBuilt 1968 · S/N TE-583 N321RR321 Rr Lp · Wimberley, TXBuilt 1968 · S/N TE-520 N321TBMob Aviation USA LLC · Auburndale, FLBuilt 1982 · S/N E-1998 N321WPRadmall LLC · Commerce City, COBuilt 1995 · S/N E-2929 N321XVerrall Charles Peter Jr · Florence, AZS/N D-5990 N3220CL00 Fliers LLC · Lewes, DES/N D-3884 N3220JFagen Inc · Granite Falls, MNBuilt 1995 · S/N E-2920 N3221RBoyes Robert L · Benton City, MOBuilt 1967 · S/N TG-27 N3222PAmlz Air LLC · Rockville, MDBuilt 1995 · S/N EA-573 N3222UMilpower Inc · Nampa, IDBuilt 1995 · S/N E-2919 N3223BTechmur LLC · Loudonville, NYBuilt 1995 · S/N E-2923 N3224QRech Jack R · Mohave Valley, AZBuilt 1999 · S/N E3224 N3225CJames Sheldon Enterprises LLC · Ontario, OHBuilt 1954 · S/N D-3890 N3225KWjm Aviation LLC · Friendswood, TXBuilt 1995 · S/N E-2975 N3226BSooner Aviation LLC · Norman, OKBuilt 1999 · S/N E3226 N3226JSimms Matthew · Davie, FLBuilt 1994 · S/N E-2855 N3226QDenning Aviation Inc · Fort Madison, IABuilt 2000 · S/N E-3326 N3227GOgden Scott S · Collierville, TNBuilt 1995 · S/N E-2927 N3227XSasar Inc · Wilmington, DEBuilt 1999 · S/N E-3227 N3228WChris I Lee Md Inc · Rowland Heights, CABuilt 1995 · S/N E-2928 N3228XN3228x LLC · Colusa, CABuilt 1995 · S/N E-2978 N3229GAero-Mark LLC · Winchester, KYBuilt 2000 · S/N E-3329 N322ETWing Bird Aviation LLC · Garland, TXBuilt 1975 · S/N TE-1016 N322HSmittys Acft Svc Inc · Oneill, NEBuilt 1951 · S/N 3184 N322HSReed Systems Ltd · Ellenville, NYBuilt 1974 · S/N D-9709 N322JBJ & R Aviation Inc · Sioux Falls, SDBuilt 1990 · S/N E-2549 N322NHBoyette Thomas E · Parker, COBuilt 1958 · S/N D-5646 N322RJAero-Mobil Inc · Wilmington, DEBuilt 1974 · S/N P-322 N322SPBurkett Gary L Trustee · Murfreesboro, TNBuilt 1968 · S/N TE-531 N322YGove Tyler A · Hoschton, GABuilt 1960 · S/N D-6351 N3230RAkradi Parviz · Irvine, CABuilt 1987 · S/N CE-1173 N3231CDigiacomo Jason T · Seaside, CABuilt 1954 · S/N D-3896 N3232CBrooks Michael B · Tehachapi, CABuilt 1954 · S/N D-3897 N3232WKilgallen Keith S · Stuart, FLBuilt 1995 · S/N E-2932 N3233GMach Aviation Pilot Services LLC · Andover, KSBuilt 1995 · S/N E-2933 N3233JZebcon Inc · Russellville, ARBuilt 1999 · S/N E3233 N3233LMann Aviation LLC · Wilmington, DEBuilt 1999 · S/N EA633 N3235CRegistration Pending · Louisville, TNRegistration pendingBuilt 1954 · S/N D-3900 N3235DMdb Ventures LLC · Wausau, WIBuilt 1995 · S/N E-2935 N3235TBhatia Kabir · Lake Oswego, ORBuilt 1995 · S/N EA-577 N3236GAvan LLC · Lynwood, ILS/N E-2287 N3236QBo'S Investments LLC · Amarillo, TXBuilt 1997 · S/N E3110 N3236THg Aviation LLC · Helena, MTBuilt 1995 · S/N E-2936 N3236VMlm Aviation LLC · Saint Francisville, LABuilt 1985 · S/N E-2271 N3236ZJuliet Sierra Foxtrot LLC · Denver City, TXBuilt 1991 · S/N EA-526 N3238YKorff Aviation LLC · Leesburg, VABuilt 1995 · S/N E-2938 N3239WHaidlen Ford Inc · Oakdale, CABuilt 1995 · S/N E-2939 N323GBGs Aviation LLC · Lebanon, TNBuilt 1975 · S/N E-647

Back to AD 99-05-13 R1 WD