OpenAirDocs.org
AD 90-06-03 R1

Registered aircraft · 20,687

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-06-03-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-06-03-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.

N9502HYoung Roger A II · Wasilla, AKFirst renewal noticeBuilt 1975 · S/N 17266182N9504HPatterson Clifford Wayne · Murphy, TXBuilt 1975 · S/N 17266184N9505HFinal Approach Aviation LLC · Danville, CABuilt 1975 · S/N 17266185N9507LBatra Sanjeev · Roseville, CABuilt 1986 · S/N 17276566N9508BRegistered aircraftBuilt 1981 · S/N 172RG0842N9508WUniversity Of Alaska Anchorage · Anchorage, AKBuilt 1998 · S/N 17280377N950ACRed Carpet Aviation LLC · Carlsbad, CABuilt 1983 · S/N 17276058N950DRRjc Skyhawk LLC · Middletown, DES/N 17268169N950LPAmeriflyers Of Texas Inc · Addison, TXBuilt 2001 · S/N 172S8950N950MEN950me LLC · Manassas, VABuilt 1976 · S/N 17266539N9510HRegistered aircraftBuilt 1975 · S/N 17266188N9510LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276568N9511DEglin Aero Club · Eglin Afb, FLS/N 17280359N95129Texas State Technical College · Waco, TXBuilt 1997 · S/N 17280264N9512FGeorge'S Aviation Services Inc · Honolulu, HIBuilt 1998 · S/N 17280429N9512HTracy Patrick J · Maddock, NDBuilt 1975 · S/N 17266190N9513BLong Michael A · Grand Lake, COBuilt 1981 · S/N 172RG0844N9513HHigh Flight Academy LLC · Allison Park, PABuilt 1976 · S/N 17266191N9514HFrerichs John E · Gurley, ALBuilt 1975 · S/N 17266192N9515BGrason Aviation LLC · Appleton, WIBuilt 1981 · S/N 172RG0846N9515QVictory Aviation Club Inc · Hamilton, OHBuilt 1998 · S/N 17280383N9515SKingsky Flight Academy LLC · Lakeland, FLBuilt 1998 · S/N 17280398N9516JEastern Kentucky University · Richmond, KYBuilt 1998 · S/N 17280396N951HCUsweixin · Sheridan, WYBuilt 1980 · S/N 172RG0282N951JAAerochatt LLC · Cleveland, TNBuilt 2007 · S/N 172S10496N951MCSky Mates Inc · Wilmington, DEBuilt 2001 · S/N 172S8951N951SCJuliet Charlie Aviation LLC · Scottsdale, AZBuilt 2013 · S/N 172S11252N951SPN591sp LLC A Series Of Aero Lease LLC · San Antonio, TXS/N 172S8151N951TAKb Land And Cattle Company LLC · Hood River, ORBuilt 2003 · S/N 172S9518N9520DHodge Flight Services LLC · Pittsburg, CABuilt 1998 · S/N 17280385N9520WAmeriflyers Of Texas Inc · Addison, TXBuilt 1998 · S/N 17280407N9520ZK2 Aviation LLC · Greenwood Village, COBuilt 2013 · S/N 172S11278N9521HJordan Recreation Development LLC · Clinton, TNBuilt 1975 · S/N 17266197N9522ADunn Legacy Inc · Saint Petersburg, FLBuilt 1998 · S/N 17280411N9522HUrbas Robert M · Rockford, ILBuilt 1975 · S/N 17266198N9522LYellow Jacket Flying Club Inc · Atlanta, GAFirst renewal noticeS/N 17276570N9522SSnohomish Flying Service Inc · Snohomish, WABuilt 1998 · S/N 17280432N9523HVictor James A · Kingsville, OHBuilt 1975 · S/N 17266199N9525VFirst Eclipse Ltd · Richmond, VABuilt 1998 · S/N 17280315N9526BWildenberg Ronald · Beloit, WIBuilt 1981 · S/N 172RG0855N9526GAtlas Aviation Tampa Inc · Tampa, FLBuilt 1998 · S/N 17280434N9526HAbove The Haze LLC · San Lorenzo, CABuilt 1975 · S/N 17266201N9528WWings Over Texas Holdings LLC · Denton, TXBuilt 1998 · S/N 17280467N9529WFlight Operations Aircraft LLC · Wilmington, DEBuilt 1998 · S/N 17280470N952JAHuerta Holdings Inc · Santa Ana, CABuilt 2007 · S/N 172S10474N952SCMike Charlie Aviation LLC · Scottsdale, AZBuilt 2014 · S/N 172S11406N9530BSierra Alpha Aeronautical LLC · San Antonio, TXBuilt 1981 · S/N 172RG0858N9530HHorizon Aircraft Sales & Leasing Inc · Chesapeake, VABuilt 2013 · S/N 172S11295N95314Menagerie Enterprises Inc · Denison, TXBuilt 2014 · S/N 172S11403N9531DAtp Aircraft 4 LLC · Wilmington, DEBuilt 1999 · S/N 17280473
Back to AD 90-06-03 R1