OpenAirDocs.org
AD 99-03-01

Registered aircraft · 75

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-03-01')
    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-03-01')
  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.

N108AClayton Harry L · Wichita, KSBuilt 1971 · S/N 140N10LACondon Anthony B · Wichita, KSBuilt 1972 · S/N 280N1114CWilliams John Scott · Norman, OKBuilt 1977 · S/N 27N1117Lipe James E · Rossville, TNBuilt 1969 · S/N 14N11SWMetkowski Leonard P · York, PABuilt 1972 · S/N 243GN13DHenshaw Fritz H · Napa, CABuilt 1971 · S/N 171N14JSMcnett Eric V · Topsham, MEBuilt 1972 · S/N 177N1524TYoung Dennis N · Glen Mills, PABuilt 1970 · S/N 41N177RFJones Gary R · Albany, NYBuilt 1972 · S/N 272N184NHarper Robert J · Broken Arrow, OKBuilt 1969 · S/N 9N19FTMahony John P · Schenectady, NYS/N 34N1UDSpontak James S · Etters, PABuilt 1970 · S/N 34N21HHDerrer Anthony R · Livermore, CABuilt 1978 · S/N 53N22FFWillat Garret I · Warner Springs, CABuilt 1973 · S/N 330N230XFWalker Neiman J · Denton, TXBuilt 1972 · S/N 209N2429Bittner Charles K · Maize, KSBuilt 1971 · S/N 118N26TEStandish Jason L · Brook, INBuilt 1971 · S/N 101N271BLVinarub Marc R · Webster, FLBuilt 1972 · S/N 271N27826Bowen Stephen T · Englewood, TNBuilt 1970 · S/N 84N279PN279p LLC · Homestead, FLBuilt 1971 · S/N 144N2866Arnold David A · Jeffersonville, INBuilt 1970 · S/N 60N3247Bartels Lance R · Freetown, INBuilt 1970 · S/N 17N333UMason Steven K · Rolla, MOBuilt 1974 · S/N 528N3450GSalmons James B · Oklahoma City, OKS/N 345GN3488Russell Tipton J · Muncie, INBuilt 1970 · S/N 32N3698Abair Alan A · Cromwell, INBuilt 1972 · S/N 297GN3BJFrazin Michael B · Bend, ORBuilt 1972 · S/N 178N3WHNorthern California Soaring Association · Livermore, CABuilt 1973 · S/N 324N3XACentral Ohio Soaring Association · Columbus, OHBuilt 1982 · S/N 252N4024Stoltz Charles T · Trenton, MIBuilt 1972 · S/N 206N411JRCollegiate Soaring Association Inc · Greeley, COBuilt 1970 · S/N 35N446EOngstad Clifford C · Surprise, AZBuilt 1973 · S/N 446N44MGShiles Darrel J · Baltimore, MDBuilt 1977 · S/N 11N468EMoore Michael D · Durham, MES/N 356GN480JNatkiel Paul · Hanover, NHBuilt 1977 · S/N 48N48MNLloyd Clee E · Canby, ORS/N 48N49765Preston Shane M · Tuttle, OKBuilt 1973 · S/N 353N4990GHigh Alpine Restaurant Ahcs Inc · Snowmass Village, COBuilt 1972 · S/N 267N4CCBrown Leslie Albert · Saint Clair Shores, MIBuilt 1972 · S/N 187N4RFJurado Alfonso E · Miami, FLS/N 338N511XMackenzie Franklin F Trustee · Cary, NCBuilt 1970 · S/N 36N55YRArmstrong Gregory A · Bonita, CABuilt 1970 · S/N 79N5668Beltz Thomas G Jr · Lehighton, PABuilt 1972 · S/N 207N56LSSouthern Eagles Soaring Inc · Butler, GABuilt 1973 · S/N 399N581AGMiner Daniel E · Columbus, OHS/N 51N6483Mrozinski Eric · Westford, MABuilt 1971 · S/N 124N6484Gray Thomas M · Magnetic Springs, OHBuilt 1971 · S/N 125N6485Atkinson Gary R · Pine Grove, PABuilt 1971 · S/N 127N6486Rippy Robert · Wichita, KSBuilt 1971 · S/N 129N6MSStafford Linda J DBA · Ann Arbor, MIBuilt 1973 · S/N 337
Back to AD 99-03-01