OpenAirDocs.org
AD 99-03-11

Registered aircraft · 32

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-11')
    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-11')
  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.

N100LSAg Flyers Inc · Torrington, WYBuilt 1969 · S/N P-116N1024LSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N P-78N1155TCaljet Aviation LLC · Magnolia, TXBuilt 1969 · S/N P-47N152URoyal Air Inc · Shreveport, LABuilt 1968 · S/N P-14N15SYGoldman Richard D · Litchfield Park, AZBuilt 1969 · S/N P-46N160CRBas Part Sales LLC · Greeley, COBuilt 1968 · S/N P-24N167UDodson International Parts Inc · Rantoul, KSS/N P-99N22KJb Earthmoving Equipment LLC · Lemont Furnace, PAS/N P-51N2GPPlanes Of Fame Air Museum · Chino, CAS/N P-56N326TCAlvarado Ruben Jr · Brownsville, TXBuilt 1969 · S/N P-121N345YWImpact Real Estate Group LLC · Casper, WYBuilt 1969 · S/N P-85N360AKLindquist Scott DBA · Minnetonka, MNBuilt 1968 · S/N P-18N399TLWilson Aircraft Inc · Independence, MORegistration revokedBuilt 1969 · S/N P-54N400BPCole Gary · Richmond, TXBuilt 1969 · S/N P-96N44WReady Aim Flyer LLC · New Castle, DEBuilt 1968 · S/N P-29N54DBMattingly Aviation LLC · Radcliff, KYBuilt 1970 · S/N P-127N55CLBoyd Larry C · Seymour, TXBuilt 1969 · S/N P-77N55VVMcnitt Todd M · Newport, ORBuilt 1968 · S/N P-20N5888LDavenport Aviation LLC · Rock Hill, SCS/N P-89N60PFSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N P-87N60RKMajeste Air LLC · Reno, NVBuilt 1969 · S/N P-79N7029DLang Ronald J · Middleburg, VABuilt 1968 · S/N P-11N7071DGottschall Kenneth Lee III · Santa Paula, CABuilt 1969 · S/N P-115N7079DYang Chin-Yuh · West Covina, CAS/N P-39N713VUhlik Daniel · Delano, CABuilt 1968 · S/N P-16N7197DJ And J Farming LLC · Halsey, ORBuilt 1969 · S/N P-70N7390DErda LLC · Wilmington, DES/N P-108N7510DK & A Duke LLC · Marcellus, MIBuilt 1969 · S/N P-101N75MJBatidas Maria Fernanda · Tucson, AZS/N P-73N763RJas & Jls Holdings LLC · Lake Point, UTBuilt 1975 · S/N P351N776Thomas Albuzat Inc · Westpoint, INNon-citizen corporation, flight hours not reportedBuilt 1969 · S/N P-111N7PFCrisp Curtis S · Lakewood, WABuilt 1969 · S/N P-52
Back to AD 99-03-11