OpenAirDocs.org
AD 90-06-03 R1

Registered aircraft · 20,683

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.

N349JMMortland Joseph A · Weymouth, MABuilt 1973 · S/N 17262619N349MEPlane Nonsense Inc · Middletown, DEBuilt 2000 · S/N 172S8584N349SPWard Michael Allen · Quinlan, TXBuilt 1999 · S/N 172S8276N34BLAmerican Asset Leasing LLC · Aurora, ORBuilt 2020 · S/N 172S12468N34GSGhavi Enterprises Inc · Kenosha, WIBuilt 2016 · S/N 172S11662N34HDWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1984 · S/N 17276259N34LCC & J Air Inc · Middletown, DEBuilt 1979 · S/N 17272203N34LVRegistered aircraftBuilt 1968 · S/N 17257507N3500SVasylenko Volodymyr V · Portland, ORBuilt 1963 · S/N 17250700N3501K3501k LLC · Southaven, MSS/N 172S8969N3504PWingsleasing LLC · Wichita, KSBuilt 2001 · S/N 17281053N3505TAa-Aero Inc · Fairfield, NJBuilt 2001 · S/N 172S8858N35063Purdue Aviation LLC · West Lafayette, INBuilt 2001 · S/N 172S8878N3506GDelta State University · Cleveland, MSBuilt 2001 · S/N 17281054N3506TBaron Logistics LLC · Metairie, LABuilt 2001 · S/N 172S8962N35077Carreno Victor A · Guaynabo, PRBuilt 2001 · S/N 17281062N35079Wings Over Texas Holdings LLC · Denton, TXBuilt 2001 · S/N 17281061N3507SBengen Dietrick K · Pasco, WABuilt 1965 · S/N 17253090N3508JDhs Operations LLC · Wilmington, DEBuilt 2001 · S/N 17281060N3508SParris Jack L · Pleasant Hill, MOBuilt 1963 · S/N 17250708N35092Iasco Flight Training Inc · Redding, CABuilt 2001 · S/N 17281044N3509QChristiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 172S8835N350EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13081N350SUOhio State University · Columbus, OHBuilt 2019 · S/N 172S12304N3510ACrotts Aircraft Service Inc · Dodge City, KSBuilt 2001 · S/N 17281042N3511RWilliam E Boyle LLC · Pittsburgh, PABuilt 2001 · S/N 172S8880N3511SRichard Daniel J · Orrington, MEBuilt 1963 · S/N 17250711N35121Snohomish Flying Service Inc · Snohomish, WAS/N 172S8844N3512TBroadway Aircraft Management Inc · Merritt Island, FLS/N 172S8883N3513FBeeca Flight LLC · Oviedo, FLBuilt 2002 · S/N 17281090N35148Century Air Inc · Fairfield, NJBuilt 2001 · S/N 172S8930N3514QReed Daniel E · Wentzville, MOBuilt 1973 · S/N 17261659N3514TAlpha Sierra Aviation LLC · Wilmington, DES/N 172S8843N3514UChristiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 172S8841N3515STm Aviation Services LLC · Riverside, CABuilt 1963 · S/N 17250715N3516SBenedict Greg · Mason City, IABuilt 1963 · S/N 17250716N3517SG & M Aircraft Inc · Wheat Ridge, COBuilt 2001 · S/N 17281083N3517VSt Cloud State University Aero Club Inc · Saint Cloud, MNBuilt 2001 · S/N 17281082N3518SVarner Gregory A · Wasilla, AKBuilt 1963 · S/N 17250718N3519UG And D Aviation LLC · Sunfish Lake, MNS/N 172S8849N351GPSelby Chris A · Monticello, ARBuilt 1968 · S/N 17256918N351JSRainier Flight Service LLC · Renton, WABuilt 2025 · S/N 172S13355N351MEPs N351me LLC · Green Bay, WIBuilt 2000 · S/N 172S8586N3520SBrosnan James M · Staten Island, NYBuilt 1963 · S/N 17250720N3521QCub Club Inc · Fort Myers, FLBuilt 2001 · S/N 172S8847N35229Coneburripul Corp · Miami, FLBuilt 2001 · S/N 172S8837N3522EKilgore William B · Eureka, CAS/N 17271572N3522QRamirez Jose Marcos · Casa Grande, AZBuilt 1973 · S/N 17261661N35230Christiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 17281017N3523RAviator Air Flight School LLC · Grand Prairie, TXBuilt 2001 · S/N 17281016
Back to AD 90-06-03 R1