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.

N998DWSpartan Education LLC · Tulsa, OKBuilt 2001 · S/N 172S9019N998RASchubert Brothers Aviation Inc · Canandaigua, NYBuilt 1973 · S/N 17261672N998SEUtter Albert · Fort Myers, FLBuilt 1988 · S/N 17274025N9990BAurora-Flight LLC · Commerce Township, MIBuilt 1982 · S/N 172RG1109N9990VCompass Aviation Inc · Shelby, NCBuilt 1974 · S/N 17264608N99917Anderson Cody Jon · Orono, MEBuilt 1986 · S/N 17276527N9991BTaft Leasing LLC · Bloomfield, NMBuilt 1982 · S/N 172RG1110N9991EWings Flight Enterprises Inc · Danville, KYS/N 17272308N9991GSale Reported · Staten Island, NYSale reported, canceledBuilt 1979 · S/N 17273639N9991VSafeway Flying Club Inc · Denmark, WIBuilt 1975 · S/N 17264609N9992VShipe Jacqueline M · Louisville, TNBuilt 1974 · S/N 17264610N9993ECruise Flight Academy Inc · Dalton, GABuilt 1979 · S/N 17272309N99948Florida State College At Jacksonville · Jacksonville, FLS/N 172-76483N9994VWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17264612N9997VBecker Philip J · Ocean Isle Beach, NCBuilt 1974 · S/N 17264614N99981Sky High Leasing Services LLC · Lakeland, FLBuilt 1985 · S/N 17276533N99991Genovese Mark A · Baltimore, MDBuilt 1985 · S/N 17276534N999AFThree Four Juliet LLC · Orange, CABuilt 1975 · S/N 17265806N999ARD R Tripp Enterprises LLC · Omaha, NES/N 17268006N999FWMontgomery Aviation LLC · Zionsville, INBuilt 1999 · S/N 172S8260N999HEPinnacle Aviation Services Inc · Encinitas, CABuilt 2002 · S/N 172S9245N999MAMccreery Aviation Co Inc · Mcallen, TXBuilt 2005 · S/N 172S9812N999QAQuebec Alpha LLC · Milwaukie, ORBuilt 1973 · S/N 17262047N999WBEastern Kentucky University · Richmond, KYBuilt 1979 · S/N 17273254N99BHBarker Aviation LLC · Ardmore, OKS/N 17260112N99EBAir Wings Enterprise LLC · Roca, NEBuilt 1963 · S/N 17250150N99HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 1999 · S/N 172S8222N99HVAerohawk LLC · Lawrence, KSBuilt 2005 · S/N 172S10090N99PGWilliams James R · Batesville, INBuilt 1978 · S/N 17272044N99PTWiger Theodore L · Falcon Heights, MNS/N 17249265N99TCUltimate Resort Vacations Inc · Weston, FLBuilt 1980 · S/N 172RG0412N99TNHuskey Ryan J · Edmond, OKS/N 17265107N99TSLorenzen Carl A · Blair, NEBuilt 1963 · S/N 17250870N9LAEvanoff Thomas E · Fowlerville, MIS/N 17249542N9MYBermudez Tacito Octavio · Conyers, GABuilt 1976 · S/N 17267616N9VUBoyer Daniel E · Brockton, MABuilt 1964 · S/N 17251361N9XFBounds Keith A · Thomson, GABuilt 1976 · S/N 17267373
Back to AD 90-06-03 R1