OpenAirDocs.org
AD 90-15-15 R1

Registered aircraft · 826

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:90-15-15-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:90-15-15-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.

N43GBHenze Stacy A · Longmont, COS/N 769-96N444PFRegistered aircraftBuilt 1979 · S/N 543-79N44HKBradt Joseph J · Inver Grove, MNBuilt 1997 · S/N 79597N44ZWTurner Robert H · San Diego, CABuilt 1977 · S/N 322-77N451KWKw Plastics · Troy, ALBuilt 1978 · S/N 451-78N451PCParkland College · Champaign, ILBuilt 2024 · S/N 1220-2024N451SABobbitt Cole T · Jasper, GABuilt 2004 · S/N 944-2004N452SPhantom Aviation LLC · Portland, ORBuilt 1992 · S/N 689-92N45MAR V Aviation LLC · Thatcher, AZS/N 1074-2008N460LMMassey Larry A · New Braunfels, TXBuilt 1977 · S/N 321-77N464SCCourtney Melissa · Okemos, MIBuilt 1999 · S/N 844-99N465ACBlue Super D LLC · Clark, NJBuilt 1999 · S/N 827-99N466SC123 Investments LLC · Clare, MIBuilt 2020 · S/N 1186-2020N469JAmerican Champion Aircraft Corp · Rochester, WIBuilt 2013 · S/N 1122-2012N474ACOverland Leasing Inc · La Porte, TXBuilt 2000 · S/N 854-99N476MAAdamko Victor W · Riley, MIBuilt 2007 · S/N 1056-2007N4775PRegistered aircraftBuilt 1975 · S/N 20675N4781TContinental Title Trust LLC Trustee · Wichita, KSS/N 170-75N484MAGibby Aviation Inc · Wilmington, DEBuilt 2014 · S/N 1147-2014N485TMitchell Lisa Marie · Lake Villa, ILBuilt 2004 · S/N 973-2004N491MABelle Casa Sport LLC · Tarpon Springs, FLBuilt 2004 · S/N 957-2004N495JCCampillo Jorge A · Miami, FLBuilt 1977 · S/N 357-77N499DPFarrington John R · Cedar Park, TXBuilt 2010 · S/N 2001-2010N501BSBlue Skies Enterprises Of Texas · Richmond, TXBuilt 2005 · S/N 1005-2005N50240Carr James T · Scotts, MIBuilt 1978 · S/N 436-78N50247Haywood Charles E Jr · Valrico, FLS/N 437-78N50259Coker Steve L III · Tyler, TXBuilt 1978 · S/N 441-78N5025EStokes Field LLC · Mount Vernon, MOBuilt 1978 · S/N 438-78N5025NMalott Corwin · Spokane, WAS/N 439-78N5025PFoley Jeffrey W · Scappoose, ORBuilt 1978 · S/N 440-78N5026BLaurie Craig M · Anchorage, AKBuilt 1978 · S/N 442-78N5026NWright Bruce M · Rosharon, TXBuilt 1979 · S/N 570-79N50271Sawyer Johnson Inc · Osceola, WIBuilt 1979 · S/N 572-79N5027FAmoia Steven M · La Mesa, CABuilt 1979 · S/N 571-79N5028FMarshall Kevin · Dekalb, ILBuilt 1979 · S/N 573-79N5028GButler Patrick F · Elko, NVBuilt 1979 · S/N 574-79N5028VFlying Lemur Inc · Alexandria, VABuilt 1978 · S/N 445-78N5029KFerrin Aviation LLC · Rome, GABuilt 1978 · S/N 446-78N5030CMckenna Kent T · Torrance, CABuilt 1978 · S/N 448-78N5030GTennis Gayland L · Bath, MIS/N 450-78N5030PEgmond Aircraft LLC · Lewes, DEBuilt 1978 · S/N 458-79N5031NRousseau Cindy L · Washington, DCBuilt 1978 · S/N 460-79N5032AHunter Aviation Inc · Benton, KYBuilt 1978 · S/N 461-79N5032FMusgrave John Robert · Morris, ILBuilt 1978 · S/N 462-79N5032URegistration Pending · Fort Huachuca, AZRegistration pendingBuilt 1978 · S/N 465-79N5034VBibler Barry D · Spearfish, SDBuilt 1978 · S/N 467-79N5034WCurran Robert A · Waldorf, MDBuilt 1978 · S/N 468-79N50350Redline Shane Z · Amarillo, TXBuilt 1978 · S/N 471-79N5035NCp Aviation Inc · Santa Paula, CABuilt 1978 · S/N 470-79N50361Mcbride Daniel · Burleson, TXBuilt 1979 · S/N 478-79
Back to AD 90-15-15 R1